http://sqlblog.com/blogs/eric_johnson/archive/tags/SQL+Server+2008/Sort+Transformation/SSIS/default.aspxTags: SQL Server 2008, Sort Transformation, SSISenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/eric_johnson/archive/2010/02/03/the-trouble-with-ssis-sorting.aspxWed, 03 Feb 2010 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:20953ejohnson20107http://sqlblog.com/blogs/eric_johnson/comments/20953.aspxhttp://sqlblog.com/blogs/eric_johnson/commentrss.aspx?PostID=20953Many SSIS transformations, such as the Pivot and the Data Profiling Tasks, require that the data being fed into them be sorted. Without first sorting, some transformations will throw an error and not run, while others will run but the results will not...(<a href="http://sqlblog.com/blogs/eric_johnson/archive/2010/02/03/the-trouble-with-ssis-sorting.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=20953" width="1" height="1">SQL Server 2008SSISSort TransformationSQL Server