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 » 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
  • Slowly Changing Dimensions - Duplicate Data Issues

    The Slowly Changing Dimension (SCD) transformations are pretty handy in SSIS packages. They let you compare a new set of data to an existing table and insert or update as needed. Alternatively, you can have them insert new rows and mark old rows as "Expired" instead of updating rows when a change occurs. This is great if you want to ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on May 5, 2009
Privacy Statement