The following section contains information on migrating SSIS packages that contain Xtract IS components from a lower SQL Server/SSIS version to a higher version.

When migrating from SQL Server 2012 or lower to SQL Server 2019, follow the instructions in Migrating from SQL Server 2008/2012 to SQL Server 2019. When migrating from SQL Server 2014 or higher to SQL Server 2019, follow the instructions in Migration from SQL Server 2014/2016 to SQL Server 2019.

Install the latest version of Xtract IS #

Install the latest version of Xtract IS on your SSIS server and any development environment (Visual Studio/SSDT).

Migrating from SQL Server 2008/2012 to SQL Server 2019 #

A migration from SQL Server 2012 to SQL Server 2019 also requires a migration of SSIS packages.

The SSIS packages are converted to run on SQL Server 2016 using the XtractIS Conversion Preparer before they can be migrated to SQL Server 2019. The XtractIS Conversion Preparer is a tool that prepares SSIS packages created for older SQL Server versions to migrate to newer SQL Server versions. You can find the XtractISConversionPreparer.exe in the installation directory of Xtract IS, e.g., C:\Program Files\XtractIS\XtractISConversionPreparer.exe.

  1. Run the XtractISConversionPreparer.exe. The window “XtractIS Conversion Preparer” opens.
  2. Click [Add file(s)] and select the packages that need to be prepared for conversion. If there is a package in the debug folder, it is automatically be included.
  3. Select the SQL Server version, for which you want to prepare the packages from the drop-down list. For migration to SQL Server 2019, select SSIS 2016 from the pull-down menu. To migrate to SQl Server 2019 the extra step via SQL Server 2016 is mandatory. During conversion, the tool creates a backup of your SSIS package.
    Recommendation: Manually create a backup copy prior to conversion.
    XIS_ConversionPreparer_2016
  4. Click [Prepare]. The conversion process is started.
  5. To migrate from SQL Server 2016 to SQL Server 2019, follow the instructions in Migration from SQL Server 2014/2016 to SQL Server 2019.

Note: The password encryption of the SSIS packages set by the ProtectionLevel property must be deactivated or changed for the conversion of the SSIS packages.

Migration from SQL Server 2014/2016 to SQL Server 2019 #

Note: SSIS packages created by an SQL Server Data Tools (SSDT) / Visual Studio (VS) version from before 2015 must be migrated to SQL Server 2016 before it can be migrated to SQL Server 2019. To migrate correctly, select SQL Server 2016 as the target version, then save and reopen the project.

  1. Open a new Solution in Visual Studio.
  2. Open the project properties and select an SQL server as “Deployment Target Version”:
    • If your SSIS packages have been created by an SSDT/VS version from after 2015 for SQL Server 2014/2016, continue with step 6.
    • If your SSIS packages have been created by an SSTD/VS version from before 2015 for SQL Server 2014/2016, select the SQL Server on which your packages have run until now (SQL Server 2014 or SQL Server 2016).
    • If the SSIS packages have been prepared by the XtractIS Conversion Preparer from Migrating from SQL Server 2008/2012 to SQL Server 2019, select SQL Server 2016.
      VS-Deployment-Target
  3. Save the project.
  4. Add the SSIS packages to the project.
  5. Save the project again.
  6. Change the “Deployment Target Version” to SQL Server 2019.
  7. If Xtract IS components are not displayed correctly in the Data Flow Task, close the Solution and reopen it. If the Xtract IS components are still not displayed correctly, close and restart Visual Studio.

Saving the project before and after the import of SSIS packages is necessary for the migration to work correctly.