You can sort the data in 2 ways

1. sort the data in database and then apply the Issorted and sortkey position on the source adapter which comes before any transformation like derived column

2. If its not possible in DB end, then use SORT transformation in SSIS which is asynchronous and blocking in nature.

Hope this helps you:-)

Durga.