This chapter deals with the migration of SSIS packages from a lower SQL Server/SSIS version to a higher version. Example: You are migrating from SQL Server 2012 to SQL Server 2017. This requires a migration of your SSIS packages, as well.
Please do also note the dependency of Visual Studio/SSDT and SSIS version, see here.
Migration from SSIS 2008/2012 to SSIS 2017
- Use the Xtract IS Conversion Preparer.
- Follow the steps as described in Migration from SSIS 2014/2016 to SSIS 2017 below.
The Xtract IS Conversion Preparer is a tool that takes SSIS packages created for older versions of SSIS which contain Xtract components and prepares them for migration to newer versions of SSIS. This tool can be found in the Xtract IS installation folder.
For migration to SSIS 2017, please select SSIS 2014 or SSIS 2016 from the pull down menu.
During conversion, the tool creates a backup of your SSIS package. However, it is still advisable to manually create a backup copy prior to conversion.
First, click on Add file(s) and select the packages from the file dialog which need to be prepared for conversion. If there is a package in the debug folder, it will automatically be included.
Secondly, select the SSIS version you are preparing the packages for from the drop down box .
Finally, clicking the Prepare button will start the conversion process.
After opening the converted package in Visual Studio and depending on the version of Visual Studio, the Visual Studio Conversion Wizard will launch and convert the package to the format of the selected Visual Studio version.
Should you encounter an error message in Visual Studio after converting the SSIS package with the Xtract IS Conversion Preparer, you may have to deactivate SSIS package protection first before running the Xtract IS Conversion Preparer. ATTENTION: When opening the converted SSIS packages in Visual Studio please change the target server version accordingly and save the SSIS package. If you selected ‘SSIS 2014’ in Xtract IS Conversion Preparer, change the target server version to ‘SQL Server 2014’. If you selected ‘SSIS 2016’cahnge to ‘SQL Server 2016’.
Migration from SSIS 2014/2016 to SSIS 2017
With VS/SSDT 2015 and 2017, you can select the target server version in the project’s properties.
For more information about supported SSIS versions, their relation to different Visual Studio versions and how to upgrade to higher SSIS versions please check: List of the SSIS/VS Versions Supported by Xtract IS