The following section contains detailed information on migrating SSIS packages (containing Xtract IS components) from a lower SQL Server/SSIS version to a higher version. Example: You are migrating from SQL Server 2012 to SQL Server 2019. This migration requires a migration of your SSIS packages, as well.

Keep in mind the dependency of Visual Studio/SSDT and SSIS version. See more details in the knowledge base article - Step-by-step instructions for migrating SSIS 2012 packages to SSIS 2019.

Migrating from SSIS 2012 to SSIS 2019 #

  1. Prepare SSIS packages for migration using XtractISConversionPreparer.exe
  2. In the SSIS package, change the target deployment environment to SSIS 2019.
  3. Install the latest Xtract IS version.

Executing XtractISConversionPreparer.exe #

The XtractIS Conversion Preparer is a tool that prepares SSIS packages (containing Xtract IS components) created for older versions of SSIS for migration to newer versions of SSIS.

Note: Only SSIS packages created with SSIS 2012 must be converted using XtractIS Conversion Preparer located in: C:\Program Files\XtractIS\XtractISConversionPreparer.exe.

For any other newer SSIS packages adjust the “Deployment Target Version” in project properties, see below.

  1. Start the XtractIS Conversion Preparer.
  2. For migration to SSIS 2019, select SSIS 2016 from the pull-down menu. During conversion, the tool creates a backup of your SSIS package.
    Recommendation: Manually create a backup copy prior to conversion.
  3. Click [Add file(s)] and select the packages, which need to be prepared for conversion from the file dialog. If there is a package in the debug folder, it is automatically be included.

  4. Select the SSIS version, for which you are preparing the packages from the drop-down list. XIS_ConversionPreparer_2016

  5. Click [Prepare] to start the conversion process.
    After opening the converted package in Visual Studio, depending on the version, the Visual Studio Conversion Wizard launches and converts the package to the format of the selected Visual Studio version.

Tip: If an error message appears after converting the SSIS package with the XtractIS Conversion Preparer, you may have to deactivate SSIS package protection first before running the XtractIS Conversion Preparer.

Warning! Package does not run successfully
When opening the converted SSIS packages in Visual Studio the target server version must be changed accordingly. Make sure to save by clicking [Save the SSIS package].

Example: If you selected ‘SSIS 2016’ in Xtract IS Conversion Preparer, change the target server version to ‘SQL Server 2016’.

Migration from SSIS 2014/2016 to SSIS 2019 #

With VS/SSDT 2015 and 2019, you can select the target server version in the project’s properties.

VS_Deployment_Target

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