Optimize SQL Data Source in SSIS ?

The following Performance tip to optimize SQL Data Source SSIS
1. Sql command Text need to mention only the list of columns needed along with NOLOCK. Pickup the required column only in the select statement.
2. NOLOCK will remove Locking at run time hence use it when ever selecting data from the table.
3. Instead of complex query create a view and use the view which will improve performance a lot.

Optimize SQL Data Source in SSIS ? was last modified: January 12th, 2017 by Justin Antony

About Justin Antony


Leave a Reply