Browse by Tags

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...

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...

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...

  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...

If you have an OLE DB Source within a Data Flow in your SSIS package, and you click on the Preview button to get a sample (max of 200 rows) of the data returned by the statement you have configured, and the server takes more than 30 seconds to return any rows, then you get the following timeout message...

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...

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...