You could also sort your data at the extraction point. That is substantially faster than the sort transform, since the heavy lifting is done on the SQL server side and not in memory via Visual Studio.