Dimension Merge SCD v1.6

Rating:        Based on 3 ratings
Reviewed:  0 reviews
Downloads: 15395
Released: Apr 8, 2011
Updated: May 10, 2011 by toddmcdermid
Dev status: Stable Help Icon

Recommended Download

Application Dimension Merge SCD v1.6 Setups.zip
application, 1605K, uploaded Apr 27, 2011 - 13548 downloads

Other Available Downloads

Source Code Dimension Merge SCD Source
source code, 628K, uploaded Apr 27, 2011 - 1847 downloads

Release Notes

Donate Time Donate Cash
Back up your packages before upgrading. Upgrading from v1.5 is partly manual because of the naming change requested by the Kimball Group.
To upgrade from an earlier version, please read through the Upgrading Instructions.
Review the Documentation for installation, usage, and optimization details.

Pragmatic Works Paid Support

Pragmatic Works has recently committed to supporting the Dimension Merge SCD! They have incorporated the code into their Task Factory suite of extensions for Integration Services. If you can't use an "unsupported" open-source extension, download the Dimension Merge SCD from Pragmatic Works.

Known Issues in v1.6

Workitem #DescriptionWorkaround
Changing Existing Dimension Column From SCD1 to Not Used Hangs BIDSIntroduce a new column to the Existing Dimension flow, edit the DMSCD to mark it as "Not Used" results in a hangUse a Union All to strip that column out of the flow

Fixed Issues

If you determine an issue listed below is not fixed - please click through to the existing issue and add a comment.
Workitem #DescriptionDate Fix VerifiedDate Included in ReleaseDate Checked-in to Source
4696Binary Business Key Not Matched2010-08-212010-08-212010-08-21
5305Simultaneous SCD1 and SCD2 Changes Handled Incorrectly2011-04-072011-04-082011-04-08
5304New SCD2 (v1.5) upgrading from 1.42010-08-212010-08-212010-08-21
5396V1.5 Editor Hanging on "Finish"2010-08-212010-08-212010-08-21
5400Runtime Hang, Resolved by Enabling Debug Options2010-08-122010-08-212010-08-21
5717Improve Message Regarding Improper Column Mapping2010-08-212010-08-212010-08-21
6032Deleted Output vs. Expired SCD2 Output2010-07-052010-08-212010-08-21
6222[KSCDv1.5 SQL2005 x86] Upgrade Validation errors occur when opening a saved SSIS Package with an incomplete KSCD Transformation inside2010-05-312010-08-212010-08-21
6318Status Output is Incorrect2010-06-182010-08-212010-08-21
6621DT_DBTIME2 support2010-08-212010-08-212010-08-21
6745KimballSCD 1.5 component hangs when using a derived column in the update scd1 output2010-08-212010-08-212010-08-21
7030Audit Tab Not Saving -1 As Default Value for New Rows2011-04-082011-04-082011-04-08
7730SCD1 Deleted in v1.6, almost works but an error2011-04-272011-04-272011-04-27

New Features

If you find a problem with one of the features below, please click through to the workitem and add a comment.
Workitem #DescriptionDate Feature VerifiedDate Included in ReleaseDate Checked-in to Source
2318Support Multiple Intra-day SCD Processing2010-07-052010-08-212010-08-21
2389Support 2005 and 2008 Side-by-Side (Same PC) Installation2011-04-072011-04-082011-04-08
5322Enable SCD 2 Date Handling Effective and Expiry Dates Set to SSIS Variable Values2010-08-212010-08-212010-08-21
5717Improve Message Regarding Improper Column Mapping2010-08-212010-08-212010-08-21

Reviews for this release