How to Upgrade from SSIS Plus versions older than v1 7 to SSIS Plus versions newer than v1 7

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: 

 

  1. Uninstall the current version of the COZYROC SSIS+ Suite.
  2. 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.
  3. Once you are on the Download page, scroll down to find the SSIS+ v1.7 SR-2 installation package. (See Figure 01 below).
  4. Install the COZYROC SSIS+ Suite v1.7 SR-2
  5. 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.
  6. Save the SSIS Package.
  7. Uninstall the COZYROC SSIS+ Suite v1.7 SR-2.
  8. Using the previous link sent in the eMail, download whatever version of the COZYROC SSIS+ Suite that you desire.
  9. 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


    • 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 ...
    • SSIS+ 1.7 Releases

      To make COZYROC's components available in the new SSDT 17 version, change the target platform version to one of the other three available options: SQL Server 2012, SQL Server 2014, or SQL Server 2016. SSIS+ 1.7 SR-1 Feb 23, 2018 Released COZYROC ...
    • 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 ...