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.
Migrating from SSIS 2012 to SSIS 2019 #
- Prepare SSIS packages for migration using XtractISConversionPreparer.exe
- In the SSIS package, change the target deployment environment to SSIS 2019.
- 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: The password encryption of the SSIS packages set by the ProtectionLevel property must be deactivated or changed for the conversion of the SSIS packages.
Note: Only SSIS packages created with SSIS 2012 must be converted using XtractIS Conversion Preparer located in:
For any other newer SSIS packages adjust the “Deployment Target Version” in project properties, see below.
- Start the XtractIS Conversion Preparer.
- 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.
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.
Select the SSIS version, for which you are preparing the packages from the drop-down list.
- 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.
Warning! Package does not run successfully
When opening the converted SSIS packages in Visual Studio the target server version must be changed accordingly e.g., if you select SSIS 2016 in Xtract IS Conversion Preparer, the target server version must be SQL Server 2016. Make sure to save by clicking [Save the SSIS package].
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.
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).