An Alternative to SSIS’s SCD Wizard
This will be the last time I plug this for a while – I promise! I just wanted to make sure this page would come up in Google for those who are struggling with the Slowly Changing Dimension Wizard in SSIS.
If you want an SCD component for SQL Server Integration Services that is a single component and doesn’t take hours and hours to execute, you ought to try out this alternative. It’s available (open-source) on CodePlex – the KimballSCD project. It’s modeled on the Kimball Method of dimension processing, which ought to make some of it’s more advanced features recognizable and very useful.
Here’s a short list of the advantages this component has over the stock SCD Wizard:
Todd McDermid’s Blog: An Alternative to SSIS’s SCD Wizard
Random Posts
Loading…