Project Description

A custom Data Flow component for SQL Server Integration Services (SSIS) that replaces the standard SCD Wizard with a superior experience, from the configuration UI to runtime performance. Performs 100x faster than the standard component, and edits are non-destructive.

(Not associated or endorsed by Ralph Kimball or the Kimball Group - but read their books and go take their courses, they're excellent!)

The Slowly Changing Dimension Wizard in SQL Server Integration Services is a very useful tool for setting up and handling slowly changing dimension processing, which is a very common requirement of Data Warehousing. The SCD Wizard is easy to configure and works as advertised.
However, there are some significant issues with it that have been experienced by many:
  1. It can be very slow.
  2. Re-running the Wizard destroys parts of the data flow.
  3. It can’t be used against all data providers.
  4. It can be hard to troubleshoot why it makes the decisions it does. Click here for more details on these and other disadvantages of the SCD Wizard
This component provides an improved design-time, maintenance, and execution experience for processing slowly changing dimensions. It provides more options to support complex dimension table processing while executing over 100x faster than the Wizard.



What you should do next:
  1. Download It
  2. Install It
  3. Use It
  4. Optimize It
  5. Subscribe to Updates
If you have any questions, review the FAQ, then post your question or problem in the discussions.

Last edited Nov 10, 2009 at 10:03 PM by toddmcdermid, version 4

Comments

No comments yet.