MSDN Blogs

Common Tasks

Archives

Archives

Visitors log

Where you folks come from?

| |

|

La bodeguita de Nacho

Expressions associated to the connection manager used by ASExecuteDDLTask (Analysis Services Execute DDL Task) are not evaluated as one would expect

Posted over 3 years ago

by Nacho Alonso Portillo
- 0 Comments
When using the Analysis Services Execute DDL Task within an SSIS package, any expressions defined for the MSOLAP100 connection manager pointed by the ConnectionName property of the instance of ASExecuteDDLTask are not evaluated after the evaluation that...
La bodeguita de Nacho

SQL Server Profiler 2008 (or 2008 R2) not showing expected columns for given events while setting up the definition of a new trace

Posted over 3 years ago

by Nacho Alonso Portillo
- 0 Comments
This week, while working in a customer, they showed to me a weird (an somehow inconsistent) experience with SQL Server Profiler. The story was like this: In a laptop that was running Windows 7 (x64) when they launched Profiler.exe (the one installed with...
La bodeguita de Nacho

Microsoft.SqlServer.Management.Smo.PartitionFunction.ScriptCreate generates syntactically invalid statements for non-numeric data types

Posted over 3 years ago

by Nacho Alonso Portillo
- 0 Comments
A colleague of mine recently came across this one problem for which I have filed a code defect so that it gets fixed in a future release. If you have a partition function whose range values are of a non-numeric data type, the generated script will...