On Installing Integration Services Versions Side-by-Side

I do not recommend installing Integration Services versions side-by-side.

Microsoft provides an article describing how to accomplish side-by-side installation of Integration Services, but the article has not been updated in over three years and the last SSIS version mentioned is 2016.

Over the years, I have helped customers who have more than one version of SSIS installed on servers and / or development machines. I’ve encountered issues each time.

Introduced in SSIS 2016 to address this scenario, OneDesigner is one way to address multiple-version management. OneDesigner allows SSIS developers to select the SQL Server version of the SSIS package. Like all solutions, OneDesigner has corners: most notably, OneDesigner emits SSIS package code in the target server version at Build timed. Until that time, developers are coding in the most-current (or currently-selected) version of SSIS. It’s possible to code SSIS executables in a more-current version, executables that are not available in the target version.

Developers may access the TargetServerVersion property by right-clicking the SSIS project in Solution Explorer, and the clicking Properties.

If OneDesigner and TargetServerVersion do not meet your needs, I recommend setting up virtual machines (VMs) for each version instead of installing multiple versions of Integration Services.

Need More Help?

Enterprise Data & Analytics offers SSIS consulting and training. How may we serve you today?

Enterprise Data & Analytics

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. :{>

Comments

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.