Installing Integration Services Versions Side by Side
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory
You can install SQL Server 2019 (15.x) Integration Services (SSIS) side-by-side with earlier versions of SSIS. This topic describes some limitations of side-by-side installations.
Designing and maintaining packages
To design and maintain packages that target SQL Server 2016, SQL Server 2014, or SQL Server 2012, use SQL Server Data Tools (SSDT) for Visual Studio 2015. To get SSDT, see Download Latest SQL Server Data Tools.
In the property pages for an Integration Services project, on the General tab of Configuration Properties, select the TargetServerVersion property and choose SQL Server 2016, SQL Server 2014, or SQL Server 2012.
|Target version of SQL Server||Development environment for SSIS packages|
|2016||SQL Server Data Tools for Visual Studio 2015|
|2014||SQL Server Data Tools for Visual Studio 2015
SQL Server Data Tools - Business Intelligence for Visual Studio 2013
|2012||SQL Server Data Tools for Visual Studio 2015
SQL Server Data Tools - Business Intelligence for Visual Studio 2012
|2008||Business Intelligence Development Studio from SQL Server 2008|
When you add an existing package to an existing project, the package is converted to the format targeted by the project .
You can use the SQL Server 2019 (15.x) version of the dtexec utility or of SQL Server Agent to run Integration Services packages created by earlier versions of the development tools. When these SQL Server 2019 (15.x) tools load a package that was developed in an earlier version of the development tools, the tool temporarily converts the package in memory to the package format that SQL Server 2019 Integration Services (SSIS) uses. If the package has issues that prevent a successful conversion, the SQL Server 2019 (15.x) tool can't run the package until those issues are resolved. For more info, see Upgrade Integration Services Packages.