SSIS Performence Tuning Tip-2

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