How to upgrade from SSIS+ versions older than v1.7 SR-2 to SSIS+ versions v1.7 SR-2 or newer.
Packages that include any COZYROC tasks or components and were created
prior to SSIS+ version 1.7 SR-2 cannot be upgraded directly to version 1.8 or later.
They must first be upgraded to SSIS+ v1.7 (SR-2).
Microsoft made changes in Visual Studio and SSDT related to the SSIS
Designer. COZYROC’s SSIS+ v1.7 includes processes to handle these changes by
changing the underlying executable type in the code of the package. It is the
only release that makes the changes necessary to migrate packages properly.
Therefore, all packages with COZYROC components or tasks must use SSIS+ v1.7
SR-2 to make the necessary changes to the packages. Going forward from there,
the packages can be safely migrated to any later release.
Here are the steps to upgrade properly to avoid package corruption:
- 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.
Figure 01
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
How to upgrade an existing COZYROC SSIS+ Suite installation to a higher version.
Before upgrading your existing COZYROC SSIS+ Suite to a higher version, we recommend that you first review this entire page in detail. Depending on your upgrade situation you may need to reference the Compatibility Charts on the Installation and ...Can different versions of COZYROC's SSIS+ Suite co-exist on the same server?
New releases of the SSIS+ Suite are always backward compatible. We will provide support for all versions of SQL Server that are still supported by Microsoft at the time the new SSIS+ version is released. Therefore, it is not necessary to run ...SQL 2012 compatibility and Upgrade
Existing packages containing Lookup Plus component and designed with SSIS+ 1.5 or older version are incompatible with SQL 2012. To have successful upgrade follow these steps: Install SSIS+ 1.6 or newer on a machine where you have existing packages ...Should I uninstall previous versions of the SSIS+ Suite before installing a different version?
You must uninstall the SSIS+ suite before installing another version of it. Also, running multiple versions of the SSIS+ suite side-by-side is not supported. This is a design decision to allow your SSIS packages to run with newer versions of the ...How To Check the Version Installed for Visual Studio, SSDT, and COZYROC SSIS+
Once you have verified which versions you have installed below, please jump over to our Compatibility Charts on the Installation and Getting Started page to make sure all of these component are compatible with each other. Demonstration Video ...