THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » SSIS » Sort Transformation   (RSS)
  • The Trouble with SSIS Sorting

    Many 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 be as expected. The answer is to sort the data before it is fed into the transformation; the ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on February 3, 2010
Privacy Statement