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

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 occurs on package load (when ComputeAllExpressions is called from CPackage::LoadFromXML), because AcquireConnection is not being called for that…

0

How an apparently innocent antivirus could kill your SSIS package performance?

Interesting story this one. I’ve been working with a customer who had a very simple package which consisted of a Sequence Container including an Execute SQL Task (which truncates the destination table) followed by a Data Flow Task. The Data Flow Task contained an OLE DB Source (a SQL Server 2000) and an OLE DB…

3

Is there any way you can execute an SSIS package whose TransactionOption property is set to Required, without having the MSDTC service running?

That was the question one develepment consultant asked me. My initial answer, was what I typically answer when I’m asked any of these questions: “I dunno, but let me check it for you.” 🙂 After reviewing the source code of SSIS runtime in SQL Server 2005, the answer is: “No, it isn’t possible.” Even in…

0

SQL Server Import and Export Wizard blowing up due to an unexpected error

  Somebody was trying to run the SQL Server Import and Export Wizard (DTSWizard.exe) in one of his machines, but when he clicked Next on the first (welcome) dialog, it showed the following error:     =================================== This wizard will close because it encountered the following error: (Microsoft SQL Server) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476…

2

Flat File Provider and Decimal/Numeric data

Last week I received the following message from a colleague:   From: <Intentionally_Removed> Sent: Tuesday, November 13, 2007 2:30 PM To: <Intentionally_Removed> Subject: Flat File Provider and Decimal/Numeric data Hi All, I hope someone of you can help me in explaining the following behavior to customer J. Although I think it is by design, I…

0

Order in which DTS Packages are displayed from SQL Server 2005 GUI

Earlier this year somebody raised the following concern:   From: <Intentionally_Removed> Sent: Wednesday, April 18, 2007 10:23 PM To: <Intentionally_Removed> Subject: SQL 2005 : DTS Packages order of display… We noticed the following when trying to open DTS Packages in SQL 2005. It seems the order of display for all the versions of the package…

0