Installing Integration Services Versions Side by Side

 

Applies To: SQL Server 2016

You can install
SQL Server 2016 Integration Services (SSIS) side-by-side with earlier versions of SSIS. This topic describes some limitations of side-by-side installations.

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 ServerDevelopment environment for SSIS packages
2016SQL Server Data Tools for Visual Studio 2015
2014SQL Server Data Tools for Visual Studio 2015

or

SQL Server Data Tools - Business Intelligence for Visual Studio 2013
2012SQL Server Data Tools for Visual Studio 2015

or

SQL Server Data Tools - Business Intelligence for Visual Studio 2012
2008Business 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 2016 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 2016 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 2016 Integration Services (SSIS) uses. If the package has issues that prevent a successful conversion, the SQL Server 2016 tool can't run the package until those issues are resolved. For more info, see Upgrade Integration Services Packages.

Community Additions

ADD
Show: