BI Thoughts and Theories

Todd McDermid (a frequent poster on the MSDN SSIS forums , and creator of the Kimball SCD component ) and I have started a new project on CodePlex along with Todd McDermid, the SSIS Community Tasks and Components (ssisCTC) project. This project is intended Read More...

A recent post on the forums was asking about running packages programmatically. The poster's package was password protected, and when running the package, they were receiving a message that one of the connection managers was failing to connect. The code Read More...

I recently had a need to scan through an SSIS package to find all instances of data flow tasks within the package. This is to support a future enhancement in BIDSHelper . However, I ended up making the code a little more general, so it can be used to Read More...