Converting an SSIS 2014 Solution to SSIS 2016

Microsoft SQL Server Data Tools (SSDT) supports “deployment targets.” This means you can use the same Integrated Development Environment (IDE) to build SSIS packages targeted for deployment to the SSIS Catalog on a SQL Server 2012, 2014, or 2016 instance of SQL Server. When I open an SSIS solution built in SSDT-BI for SQL Server 2014…

Upgr2016_0

…the project is opened as a SQL Server 2014 project:

Upgr2016_2

Note the “(SQL Server 2014)” beside the project name in Solution Explorer.

If I want to deploy this project to an SSIS Catalog on a SQL Server 2016 instance, I should update the project to SSIS 2016. How do I do this? In Solution Explorer, right-click the project name and click Properties:

Upgr2016_3

Navigate to the Configuration Properties\General page. Click the TargetServerVersion dropdown and select SQL Server 2016:

Upgr2016_4

When you click the Apply button, an informative dialog displays and asks if you “want to make the change now?” Click the Yes button to change the target SSIS Catalog version to SQL Server 2016:

Upgr2016_5

Another dialog prompts you to save the changes. Click the Yes button to save the changes you just made:

Upgr2016_6

Once the changes are complete, click the OK button to return to Solution Explorer in SSDT:

Upgr2016_7

No more parenthetical version metadata, your project has been targeted for SQL Server 2016:

Upgr2016_8

:{>

Learn more!

Related Training:
IESSIS2: Immersion Event on Advanced SQL Server Integration Services

Related Articles:
Installing SQL Server 2016 Developer Edition, One Example
SQL Server 2016 Developer Edition is Free
Deploying a Single Package First in SSIS 2016
Stairway to Integration Services

Related Books
SSIS Design Patterns

Help!
Enterprise Data & Analytics – We are here to help.

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

2 thoughts on “Converting an SSIS 2014 Solution to SSIS 2016

  1. After I convert to 2016, everytime I change configuration environments it asks if I want to downgrade says:

    Any idea how to fix this?  Once I answer no for each environment it goes away until the next time I open the solution and then when I switch environments it does the same thing all over again.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.