v1.3 for SSIS 2005 and SSIS 2008

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 1370
Released: Oct 19, 2008
Updated: Feb 12, 2009 by toddmcdermid
Dev status: Stable Help Icon

Recommended Download

Application KimballSCD2005.zip
application, 74K, uploaded Oct 19, 2008 - 565 downloads

Other Available Downloads

Application KimballSCD2008.zip
application, 74K, uploaded Oct 19, 2008 - 427 downloads
Example KimballSCDSample2008.zip
example, 157K, uploaded Oct 19, 2008 - 378 downloads

Release Notes

This release is in 2005 and 2008 versions - please download the correct ZIPs for your environment. Each ZIP contains two DLLs that need to be installed on your system - see the Binary Installation Instructions to install the component.
The KimballSCDSample2008.Zip contains the package used in the video demos, and is currently only available in SSIS 2008 format. (Follow the videos (Part One, Part Two) to make your own 2005 version.)
Please come back and rate this release, or give some feedback to help others evaluate whether it's worth their time!

Changes:

  • Faster Editor UI - due to component validation only occurring on smaller subsets of the component, rather than the whole component being validated after every configuration change.
  • Surrogate Key Generation Fixed - in instances where optimized SK generation is NOT used (inputs aren't sorted, and/or "next SK" variable isn't supplied) and records from the Existing Dimension input get classified as "invalid" (due to NULL or duplicate BK detection), those "used" SKs weren't being taken into account, possibly resulting in assigment of already used SKs. Finding that situation was three "maybes" on top of an edge case... but it did happen to me when I had badly formed data (all my fault too).
  • More cautious resource locking.
  • Release a 2005 version

Known Issues

Reviews for this release

     
The Kimball Method SCD component makes a significant contribution to the MSSQL/SSIS world in giving package developers a viable alternative to the stock SCD wizard. A download, build and installation of the source code distribution went smoothly with a minimum of trouble. Tests of both SCD1-only and SCD1/SCD2 data flows seemed to give the expected results.
by dfrazier on Nov 3, 2008 at 6:58 PM