Set IsSorted Property as true:
- If you know that the source data is sorted in such scenarios set the IsSorted =true on the source adapter output.
- Go to the advanced editor by right clicking on source adapter.
- Go to input and output properties there you will be found IsSorted option .set it is true.
- By setting this value it does not perform a sort operation ,it only indicates that the data is sorted..
- By following this tip we can save some time in real time..if our data base is so large then it will helps a lot.. you can see SSIS performance tuning tip 1
