Sunday, October 5, 2014

How to improve performance when we need to merge data from several data sources?

For merge operation, input data must be sorted. So, we generally use Sort to sort data. And the SSIS package looks like the following:


But it has a performance issue. If the data source has too many number of records, it becomes very very slow. So, the solution is to avoid the use of Sort component.


To do this, go to the Advanced Editor of source component and change the following proterties:


1 means ----> ascending
-1 means ---> deascending



After completing the above steps, you will see the that the package is executed faster compared to the previous scenario.

No comments:

Post a Comment