Performance Tuning in SSIS

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

This article talks about tuning the dataflow for 5 million EBCDIC records at 497 bytes per record.  Impressively, the execution time for the dataflow task was cut almost in half by employing a number of tuning practices. 

Read the article at:

http://www.sql-server-performance.com/articles/per/ssis_ebcdic_conversion_p1.aspx

Advertisements

Tags: , ,

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


%d bloggers like this: