The SSIS Script Task and Script Component editors don't provide functionality (available in full VS) to add a reference to unmanaged COM components. Can this be done at all? Well, yes, although lack of GUI option in VSA (which SSIS uses for editing...

I was forwarded a question about SSIS Script Component on 64-bit, I think the answer may benefit others as well: Currently we are referencing a 32-bit third party component in a script component and running the SSIS package in 32 bit mode on a X64...

Runying Mao and Len Wyatt did a great study of SSIS performance, and posted some results: Getting Optimal Performance with Integration Services Lookups http://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration...