How to fix SSIS Error PerformUpgrade method failed - The component could not be upgraded to the newer version – ZappySys Help Center

Problem

Sometimes you may get the following error after you open SSIS Packages that use SSIS PowerPack.

The component metadata for "XXXXXX, clsid {XXXXXXX}" 
could not be upgraded to the newer version of the component. 
The PerformUpgrade method failed.

The component is missing, not registered, not upgradeable, or missing required interfaces.

You may also see an additional error like the below.

Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: 
The version of <your component name> is not compatible with this version of the DataFlow. 
[[The version or pipeline version or both for the specified component is higher than 
the current version. This package was probably created on a new version of DTS 
or the component than is installed on the current PC.]] 
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(
IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)

Cause

A possible reason for this error is, that you are trying to run/open SSIS packages that are designed with a higher version of SSIS PowerPack but you have an older version of SSIS PowerPack installed on your Workstation / Server where you are running or opening SSIS Package. For example, you developed packages on Workstation with higher v4.2.0 but on the server, it's older v4.0.0. So when deploying packages on a server it triggers Upgrade Process due to version mismatch and it fails because component downgrade is not allowed.

This error only comes if you used ZappySys Data Flow Components. If you used Only ZappySys Control Flow Tasks then you should not see this error.

Solution

To fix this error make sure you have the same version of SSIS PowerPack installed as the original author of the SSIS Package. You can also use the higher / latest version of SSIS PowerPack but it cannot be lower than the original version used to create SSIS Package.

Download the higher / latest version of SSIS PowerPack.
On the Server, Stop all the jobs which contain the ZappySys PowerPack Tasks/Components.
On the development machine, just close the Visual Studio and SQL Server instance(s).
Uninstall the older version of SSIS PowerPack from the Control Panel.
(Go to control panel -> Add Remove programs -> Uninstall SSIS PowerPack)
Re-install the SSIS PowerPack with Typical Default Setting.
On the Server, Start stopped jobs and test them out.

Download SSIS PowerPack For Paid Customers

Download SSIS PowerPack For Trial Users

Useful Links

How to check the Version of my SSIS PowerPack or ODBC PowerPack

How to download the FULL Version (Latest or Older Build)