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