http://sqlblog.com/blogs/eric_johnson/archive/tags/SQL+Server/Sort+Transformation/default.aspxTags: SQL Server, Sort TransformationenCommunityServer 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">Sort TransformationSQL ServerSQL Server 2008SSIS