Kimball Method SCD v1.5
Other Available Downloads
Release ZIP contains installers for SSIS 2005 and 2008 - both in 32 and 64 bit versions.
To Upgrade From v1.4
BACK UP your existing packages before installing and using v1.5
After installing v1.5, you will need to edit those packages with a text editor to make one small change, full details are in the v1.5 Installation Instructions
Excellent tool, well done! From my experieence, SCD always performs very slow if there are more than 9000 rows in the dimension to process. I have therefore had to customise it to use Conditional Split and Lookup tasks instead. For deletion, I have had to use EXCEPT() in the Execute SQL Task. I found out about this Kimball SCD later and it has simplied and sped up the warehouse development.
on Jan 23, 2011 at 11:44 AM
This is by far the best SSIS component that I have downloaded from CodePlex. I especially like the Auditing fields.
on Aug 27, 2010 at 4:03 PM
I tell you this guys !!
You deserve an award medal from Microsoft for this component.
Its miles ahead of microsofts own component
on Jul 23, 2010 at 9:25 AM
We're under the gun to complete our warehouse and have a very small team (2). This component saved tons of work and consulting expense. All we need now is an SCD2 range lookup transform for fact loads!
on Jul 15, 2010 at 3:28 PM
This is an excellent, stable and high performing component. If you are a follower of the Kimball dimensional methodology, then this is definately a time saving component for you. And, it will keep you honest at the same time by making you think about auditing and providing all the details you need to store in the Kimball recommended audit database. And, the forum feedback is always timely.
on Apr 13, 2010 at 3:53 PM
This component is very powerful and keeps improving with each release. Excellent work!
on Mar 30, 2010 at 11:04 PM
Opera does not support ClickOnce X
To install this application, save it and then open it. Opening it directly from Opera will not work correctly.