Recently we came across a case where the customer was running a Data Flow Task that was executing to it's completion without transferring any data. We finally figured out the whys. Rather than let the good research go to waste, we're posting the...

When a package is being loaded, the runtime will enumerate all of the connection managers, tasks, and data flow components on the system. It does this by looking in certain directories (under <sql>\100\dts), and also by looking in COM registry for...