BI Thoughts and Theories

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