How to Speed Up SSIS Derived Columns Transformations

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 change more than one column in a data flow by using a Derived Column task, there is a performance benefit to splitting that transformation into multiple Derived Column tasks in the same execution tree: 

a Single DC  versus: Increase the throughput by splitting the DC operations across multiple tasks   

Read all about it at the SQLCAT site:



GD Star Rating
GD Star Rating
How to Speed Up SSIS Derived Columns Transformations, 4.3 out of 5 based on 15 ratings
Henk posted at 2010-8-20 Category: Performance tip, SSIS

Leave a Reply

(Ctrl + Enter)

Better Tag Cloud