SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

Browse by Tags

Tagged Content List
  • Blog Post: Optimizing the Slowly Changing Dimension Wizard

    As a follow-up to my previous post about SCD processing in SSIS , I thought I’d go deeper into using the built-in Slowly Changing Dimension Wizard . While there are definitely more efficient ways to do SCD processing in SSIS, there are some optimizations you can apply to the components that the wizard...
  • Blog Post: Handling Slowly Changing Dimensions in SSIS

    I had a great time at PASS last week, and had a chance to talk to a lot of different SSIS users. One of the big topics seemed to be Slowly Changing Dimensions – I had a number of people ask for various improvements to the current Slowly Changing Dimension Transform in SSIS, and also ask for recommended...
Page 1 of 1 (2 items)