the component is missing, not registered, not upgradable, etc. - SQL 2016 Multiple Hash Oct 14, 2015, Beta



I saw the previous issue with the same error but I've open this one since I am using SQL 2016 Multiple Hash Oct 14, 2015, Beta with VS 2015.

I am not sure I should just use an earlier version of VS or could this issue be related to the Beta.

Here is the full error:
[SSIS.Pipeline] Error: The component metadata for "Multiple Hash, clsid {4F885D04-B578-47B7-94A0-DE9C7DA25EE2}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
[Multiple Hash [12]] Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "http://ssismhash.codeplex.com/".
[SSIS.Pipeline] Error: Multiple Hash failed validation and returned error code 0xC0048021.
[SSIS.Pipeline] Error: One or more component failed validation.
Closed Jul 21, 2016 at 12:36 PM by kmartin
Release includes VS 2015 support and SQL 2016 support.


DYaari wrote Jan 22, 2016 at 11:47 AM

I'm having the same problem. I'm using Visual Studio 2015 with Multiple Hash

When opening an existing project with Multple Hash 2014.

Error loading CRM.MD.New_SecteurDlg.Sector.dtsx: The "Multiple Hash" failed to cache the component metadata object and returned error code 0x80131600.

Can someone help us please?

kmartin wrote Mar 10, 2016 at 10:45 AM

Sorry for the delay, I didn't get an email notification so I didn't know this was here.
I haven't worked on VS2015 yet, so I'll have a look at what the underlying issue is.
Probably related to later SQL 2016 builds from the one that this was built on.

kmartin wrote Mar 10, 2016 at 12:36 PM

This is really strange.
I've traced what's happening and SQL 2016 is NOT applying the upgrade from the MultipleHash2014 to MultipleHash2016, even though it is loading the upgrade xml instructions.

MultipleHash2014 -> MultipleHash2014
MultipleHash2012 -> MultipleHash2016
MultipleHash2008 -> MultipleHash2016

If you install MultipleHash2014 onto the server/workstation then the SSIS package will run using DTEXEC v13 (2016) but executing the 2014 version of MultipleHash.

VS2015 will create a package using MultipleHash2016, but the UI doesn't work in 2016 mode.
It does appear to work in 2014 mode.

I don't know if it's bugs in MultipleHash or a combination of SQL Server 2016 and VS 2015.

The work around is to force install the SQL 2014 version of Multiple Hash onto the server/workstation with a custom install, and then at least the package will run.

kmartin wrote Mar 13, 2016 at 11:22 AM

I believe that this is caused by a bug in SQL Server 2016 RC0, and have raised a connect issue about it.


Alternate Workaround:

After using VS 2015 to upgrade from 2014 to 2016, right click on your SSIS package in the solution browser, and select View Code.
Do a global search for MultipleHash2014 and replace with MultipleHash2016
Save your package, and it will now work.

Also grab the latest beta version, as it has a bug fix that restores the UI, which was broken.

wrote Mar 13, 2016 at 11:22 AM

kmartin wrote Mar 15, 2016 at 11:48 AM

This has been fixed in the latest beta release.
Please download, as this now has the new .extensions.xml file included to handle VS2015 and SSDT's multiple targetting capabilities.

wrote Jul 21, 2016 at 12:36 PM

wrote Jul 21, 2016 at 12:36 PM