Error Message: The task with creation name SSIS.ReplacementTask is not registered for use on this computer.

Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer.

Action:
Attempting to open an SSIS package in Visual Studio you might get, under certain circumstances, the error below:

Error Message:
The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer.

Here is an example of the error:

Solution:
There are multiple scenarios in which you could receive the error when opening a package, each with their own matching solution:

I. COZYROC SSIS+ Suite has not been installed.

The solution is firstly to install properly the COZYROC SSIS+ and then to open the package. 
 
II. An improper SSDT (SSIS Projects) extension is used.

Before performing any change in your environment, you should always check the COZYROC Compatibility Charts. In case you are using an SSDT (SSIS Projects) extension version which is different from the recommended one in the Compatibility Charts, then you could receive this error message.

For instance, in case you try to edit a package with SSDT (SSIS Projects) version targeted for SQL Server 2022, but using COZYROC SSIS+ version that does not include support for SQL Server 2022, you could receive this error.

The solution would be the following:
  1. Uninstall the current version of the COZYROC SSIS+ Suite.
  2. Uninstall the current SSDT (SSIS Projects) Extension.
  3. Install the proper (recommended in the Compatibility Charts) version of SSDT (SSIS Projects) Extension.
  4. Install the COZYROC SSIS+ Suite keeping all the defaults.
In case you still have a corrupt package (after making sure you set your environment properly (as described above), you could also try to manually replace in the .DTSX file the lines, containing the words "SSIS.ReplacementTask" with the proper ones depending on the task you are using.  For instance, for Data Flow Task Plus the replacement should be as follows:
      DTS:CreationName="SSIS.ReplacementTask" with  DTS:CreationName="CozyRoc.Pipeline"     
      DTS:ExecutableType="SSIS.ReplacementTask" with  DTS:ExecutableType="CozyRoc.Pipeline"
and check if the package opens up fine.

III. Upgrading or adding an older package from COZYROC SSIS+ version 1.7 or lower directly to version 1.8 or above.

The package you have opened is corrupt due to an anomaly in the normal upgrade process to a higher version of SSIS+.  Specifically, this particular case would happen when going from version 1.7 or below to 1.8 or higher, without first upgrading to COZYROC SSIS+ Suite version 1.7 SR-2.

To confirm this, open the raw package .DTSX file in a text editor and search for “ReplacementTask”. If you find it, this means the package is corrupt.

Packages that included any COZYROC tasks or components and were created prior to COZYROC SSIS+ version 1.7 cannot be upgraded directly to version 1.8 or later.  For example, you cannot upgrade a package with DFT+ created with SSIS+ v1.6 to SSIS+ v1.8 or above, without first upgrading the package to SSIS+ v1.7 SR-2.
In order to resolve this issue, you will need to use an uncorrupted version of your SSIS package and start over with the upgrade. The specific steps, in order, are below.
Version 1.7 SR-2 included processes that changed the underlying executable type in the code of the package, which was needed as a result of Microsoft separating the SSIS functionality from VS into a now separate SSDT.
We can see in the screenshot below, that the upgrade to the package from v1.6 to v1.7 SR-2 changed the DTS:ExecutableType from "CozyRoc.SqlServer.SSIS.DataFlowTaskPlus12" to "CozyRoc.Pipeline".

Here are the steps to upgrade properly. Be sure to start with packages from before the corruption occurred: 
Uninstall the current version of the COZYROC SSIS+ Suite.
In order to download the COZYROC SSIS+ Suite v1.7 SR-2 you will need to submit the Download Form. Note: you will receive an eMail with a link that brings you to the Download page.
  1. Once you are on the Download page, scroll down to find the SSIS+ v1.7 SR-2 installation package. (See Figure 01 below).
  2. ​Install the COZYROC SSIS+ Suite v1.7 SR-2
  1. Make a slight change to all of your SSIS packages that contain any COZYROC components or tasks. The change can be as simple as adding a space to one of the task names in the package.
  2. Save the SSIS Package.
  3. Uninstall the COZYROC SSIS+ Suite v1.7 SR-2.
  4. Using the previous link sent in the eMail, download whatever version of the COZYROC SSIS+ Suite that you desire.
  5. Install the COZYROC SSIS+ Suite.
Note: your license.dat file will still exist so you do not have to retrieve the license key from the server.



    Book a Presales Call

     

    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now.