SQL 2012 compatibility and Upgrade

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 designed with SQL 2005 or 2008.
  • Open the existing package containing Lookup Plus component and re-save.

The saved package will now contain SQL 2012 compatible data and the package is ready for upgrade.


    Book a Presales Call

     

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

      • Related Articles

      • Match multiple columns with Lookup Plus

        You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...

      • How to upgrade a script in Script Component Plus from 2005 to 2008

        How to upgrade a script from 2005 to 2008 In order for this process to work, you must have both SQL 2005 and 2008 installed side-by-side on the same machine. Most of the scripts published in the public script repository are for SQL 2005. However they ...

      • How to upgrade a script in Script Task Plus from 2005 to 2008

        How to upgrade your script from 2005 to 2008 In order for this process to work, you must have both SQL 2005 and 2008 installed side-by-side on the same machine. Most of the scripts published in the public script repository are for SQL 2005. However ...

      • How can I dynamically modify a transformation in an SSIS Data Flow Task?

        COZYROC's Data Flow Task Plus allows you to dynamically modify source, destination and transformation components at runtime. For an overview and listing of properties for the following transformations, please check out the side menu item "Parameters" ...

      • 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 ...