Archive for the ‘SSIS’ Category

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 […]

Reading as fast as possible from a table with SSIS (Part II) (2010-5-13)

Recently I blogged on how to be as selective as possible while reading from and OLE DB Data Source (Part I) and how to load the data from a single flat file as fast as possible into a SQL Server table. But you probably noticed that “Out of the box” SSIS reads data faster from […]