Performance Comparison between Data Type Conversion Techniques in SSIS 2008

Try to use Transact-SQL conversion in your SSIS packages when you have several million rows!
Why? Just read this article! 🙂

The results (30 million rows):

Time(sec):
Baseline = 35 sec
Transact-SQL conversion = 46 sec
Conversion on the OLE DB Source component = 45 sec
Data Conversion transformation = 49 sec
Derived Column transformation = 71 sec

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s