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:
- Uninstall the current version of the COZYROC SSIS+ Suite.
- Uninstall the current SSDT (SSIS Projects) Extension.
- Install the proper (recommended in the Compatibility Charts) version of SSDT (SSIS Projects) Extension.
- 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.
- Once you are on the Download page, scroll down to find the SSIS+ v1.7 SR-2 installation package. (See Figure 01 below).
- Install the COZYROC SSIS+ Suite v1.7 SR-2
- 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.
- Save the SSIS Package.
- Uninstall the COZYROC SSIS+ Suite v1.7 SR-2.
- Using the previous link sent in the eMail, download whatever version of the COZYROC SSIS+ Suite that you desire.
- 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 and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Cannot create a task from XML for task, type SSIS.ReplacementTask due to error The parameter is incorrect.
Action: After upgrading from SQL 2016 to SQL 2019 and upgrading SSIS+ from 1.8 to 2.0 I opened the package in VS2019 and received the following error message. Error Message: ''Cannot create a task from XML for task, type SSIS.ReplacementTask due to ...DataFlowSetting .NET attribute used with Data Flow Task Plus
The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...How to build the data flow setup
The initialization and user interface for a data flow is defined by implementing properties on the script EntryPoint class. The documentation and samples of Script Task Plus for defining parameters is relevant to the Data Flow Task Plus ...Data Flow Task Plus editor doesn't open
Action: When I click twice on Data Flow Task Plus Component I get the following error: Error: Data Flow Task Plus' Editor doesn't open and instead of the I get the control flow tab. Solution: To solve the issue you should complete the steps below: ...Where can I find the documentation for the Data Flow Task Plus?
You can find documentation related to all the COZYROC SSIS+ Suite tasks from the main products page. Specific documentation for the Data Flow Task Plus can be found at the following link. For many of the tasks and components, you can find an ...