Kimball Method SCD v1.4

Rating:        Based on 6 ratings
Reviewed:  6 reviews
Downloads: 4656
Released: Apr 6, 2009
Updated: Sep 23, 2009 by toddmcdermid
Dev status: Stable Help Icon

Recommended Download

Application Kimball SCD 2008.msi
application, 493K, uploaded Apr 6, 2009 - 1969 downloads

Other Available Downloads

Application Kimball SCD 2005.msi
application, 922K, uploaded Apr 6, 2009 - 1119 downloads
Example Kimball SCD Sample
example, 16942K, uploaded Apr 6, 2009 - 926 downloads
Example Kimball SCD Sample
example, 15840K, uploaded Apr 6, 2009 - 642 downloads

Release Notes

Please Rate and Review this Release

Both I and users that come after you appreciate your ratings and reviews. If it's a steaming pile of cr**p, say so! If it works for you, how significant is your Performance Improvement? Please review the Binary Installation Instructions - there is one manual step.


  • Created Installers for SSIS 2005 and 2008 for "easy" component install. Still requires manual addition to SSIS toolbox, and currently doesn't Support 2005 and 2008 Side-by-Side (Same PC) Installation
  • Improved to Add Inferred Member Support. Early-arriving facts can now tag their dimension members for later update by this component.
  • Improved editor responsiveness (editor validation is asynchronous)
  • Improved handling of input re-attachment/re-definition (removing and attaching inputs doesn't discard configuration settings)
  • Significant performance (speed, memory, and CPU) improvements
  • The ability to Limit Output Columns in order to reduce/eliminate the SSIS "output column is not used" warnings.
  • Added more debugging verbosity to assist in troubleshooting, or for examination of the way the component works.
  • Improved to Extend Auditing Support with Performance Statistics


Known Issues

Reviews for this release

I would highly recommend this component to anyone using SSIS to manage SCDs. We have been using the component for over a year on dimension tables with > 2M rows in SQL Server. We recently began moving to a Netezza server and continue to leverage the KM-SCD component.
by fred_mumble on Nov 14, 2009 at 8:27 PM
This is a great addition to the SSIS ETL toolkit. Running against Oracle, non-destructive edits, case-insensitivity, auditing. Made me one happy BI-type.
by dvernet on Oct 14, 2009 at 2:12 AM
Excellent tool that will save me hours of time in hand coding that i would have had to done if i used the slowly changing dimension wizard. I hope Microsoft lift there game and make yu an offer you cannot refuse so that ssis 2010 has this component!
by RobertCooke70 on Aug 25, 2009 at 3:35 AM
This is probably the best component provided to the community. I have had outstanding success with this component so far. The fact that you do not charge for it is admirable. Outstanding JOB Todd!!!!!!!!!!
by pgburdett on Aug 6, 2009 at 7:38 PM
performs very well. Stable. excellent addition to my tool box
by WeeeBob on Aug 5, 2009 at 9:11 AM
Outstanding effort in enhancing to incorporate real world usage scenarios. Really looking forward to 1.5 enhancements but felt that the effort with 1.4 was impressive.
by JoeSalvatore on May 6, 2009 at 2:40 PM