How to Speed Up SSIS Derived Columns Transformations (2010-8-20)
Sedat Yogurtcuoglu noticed that’s it’s possible to increase the throughput of a pipeline by splitting Synchronous Transformations into Multiple Tasks in the same synchronous execution tree; we ran a series of tests with various number of Derived Column tasks and found out that it’s possible to more than double the throughput. If you want to […]