SQL Server 2012 update


I'm looking for the SQL Server 2012 SSIS Dimension Merge SCD Component.
Thanks in advance for any help.

file attachments


toddmcdermid wrote Apr 5, 2012 at 1:19 AM

Currently not supported for SQL 2012 - keep watching for an update!

TODeveloper wrote May 2, 2012 at 4:15 PM

Any ideas when it will be supported?? I don't want to have to use something else...

wrote May 5, 2012 at 4:07 PM

pauljoubert wrote Jun 23, 2012 at 10:22 AM

Do you have a timeline for updating this component for SQL 2012?

wrote Jun 27, 2012 at 5:01 PM

wrote Jul 30, 2012 at 4:23 PM

wrote Aug 6, 2012 at 1:06 PM

wrote Aug 15, 2012 at 9:23 PM

chumeniuk wrote Aug 15, 2012 at 9:24 PM

Wanting to see if an update was coming any time soon? It appears that Pragmatic was able to get the component to work with 2012.

wrote Aug 17, 2012 at 12:35 PM

wrote Aug 24, 2012 at 6:19 PM

wrote Sep 29, 2012 at 11:43 AM

wrote Nov 19, 2012 at 8:53 AM

portisto wrote Nov 24, 2012 at 7:23 PM

Still no 2012 version? Please guys..

knyazs wrote Nov 28, 2012 at 2:40 PM

Hi everyone!

I just couldn't wait more for SQL Server 2012 version of this component, so I decided to "workaround": I created wizard for generating TSQL MERGE statement. Maybe it's not so fast as this component, but at least it's FREE.

My project definitely needs more testing and I will be very pleased if you could give me your opinions. Check it here: https://scdmergewizard.codeplex.com/

wrote Jan 31, 2013 at 10:43 AM

wrote Feb 22, 2013 at 12:28 AM

wrote Mar 8, 2013 at 11:16 AM

wrote Mar 27, 2013 at 10:45 PM

dro456 wrote Mar 27, 2013 at 10:46 PM

It's almost been a year since the last post... any updates?

dro456 wrote Mar 27, 2013 at 10:46 PM

wrote Apr 26, 2013 at 4:21 AM

wrote Jun 24, 2013 at 9:31 AM

mohit123narang wrote Jun 24, 2013 at 9:31 AM

Any Update for this :? I am still looking for the free version as I can't afford a paid version.

CINUE wrote Jun 25, 2013 at 5:01 PM

I have updated the component to work in SSIS 2012, I'm running tests, if that it works correctly i will publish a link to download.

CINUE wrote Jun 27, 2013 at 5:26 PM

I use this resources to migrate the component to SSIS 2012:


the common problems are where find dependency assemblies for SQL 2012:

C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.DataTransformationServices.Controls\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.DataTransformationServices.Controls.DLL v11

C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\Microsoft.DataTransformationServices.Design.DLL v11

I changed signing key and version too.

i hope this helps.

wrote Jun 28, 2013 at 9:57 PM

CINUE wrote Jun 28, 2013 at 9:57 PM

i share my compiled components for SSIS 2012.

wrote Jun 28, 2013 at 9:59 PM

wrote Jul 31, 2013 at 2:48 PM

wrote Aug 5, 2013 at 5:56 PM

lexsmeets wrote Aug 9, 2013 at 11:08 AM

Thans for the new version. However, we run into an anoying problem when using the component. It looks like it switches the input path of the existing dimenstion and the source data when you reopen it in desing mode and klick 'Finish'.

It results in a change of fields in the output paths.

CINUE wrote Aug 21, 2013 at 11:43 PM

This issue and error "Number of Existing Dimension columns selected (17) doesn't match expected count (43)" seems to be a problem in serialize and deserialize the xml of property "Existing Dimension Columns".

I'll update the component when the problem is fully corrected.

wrote Sep 19, 2013 at 4:45 PM

wrote Sep 30, 2013 at 12:46 AM

RadimHampel00 wrote Oct 1, 2013 at 4:17 PM

Hi, do you have any update on the serialization? We ran into same problem recently. If you want any help with development, let me know.

wrote Oct 1, 2013 at 5:54 PM

CINUE wrote Oct 1, 2013 at 5:54 PM

I share the source code in case anyone wants to help solve the problem.

wrote Oct 10, 2013 at 9:33 PM

wrote Nov 4, 2013 at 8:40 PM

pedelstein wrote Jun 2, 2014 at 9:27 PM

Has anyone been able to successfully get this to work with 2012? Everything appears to work fine until the package is run and then get an error "The component metadata for Dimension Merge Slowly Changing Dimension could not be upgraded to the newer version of the component"

Anyone else have this issue or know how to get past it?

pedelstein wrote Jun 3, 2014 at 3:20 PM

Here is the exact error. If anyone has any suggestions or things to let me know.

[SSIS.Pipeline] Error: The component metadata for
"Dimension Merge Slowly Changing Dimension 1, clsid {874F7595-FB5F-40FF-96AF-FBFF8250E3EF}"
could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

[Dimension Merge Slowly Changing Dimension 1 [2]] Error:
The component is missing, not registered, not upgradeable, or missing required interfaces.
The contact information for this component is "".

[SSIS.Pipeline] Error: Dimension Merge Slowly Changing Dimension 1
failed validation and returned error code 0xC0048021.

CINUE wrote Sep 9, 2014 at 9:12 PM


You don't have installed the component correctly, and if you are migrating your package from 2008, you need to change manually the component string in package by editing the xml,because the version attached for 2012 has different public key token and version:
<property dataType="System.String"  name="UserComponentTypeName">MouldingAndMillwork.SSIS.DimensionMergeSCD, DimensionMergeSCD110, Version=, Culture=neutral, PublicKeyToken=5b38e594cb4f6ad4</property>

pixelbaker wrote Apr 30 at 6:07 PM

I'm a little bit unclear on how to install just this component rather than installing the 2008 version first - pretty sure I'm missing something. I've copied the two DLLs attached to this issue to /SQL Server/110/DTS/PipelineComponents for both the Program Files (x86) and Program Files directories, but no dice in getting them to show up in the toolbox when I launch VS 2012. Any tips apprecited.

VerdonTrigance wrote Oct 27 at 2:59 PM

I have same error that Pedelstein has.
But I'm not migrating from 2008, but create new package. In the package xml 'UserComponentTypeName' is correct.
I have copied both 'SSISComponentUtilities110.dll' and 'DimensionMergeSCD110.dll' to 'C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents' and 'C:\Program Files\Microsoft SQL Server\110\DTS\Tasks'
I also installed them into GAC throught powershell like this:
Set-location "C:\Soft\Microsoft\SQL Server\DimensionMergeSSIS2012"
[System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
$publish = New-Object System.EnterpriseServices.Internal.Publish
$publish.GacInstall("C:\Soft\Microsoft\SQL Server\DimensionMergeSSIS2012\SSISComponentUtilities110.dll")
And now they are in 'C:\Windows\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a...'
So question is what I missed?