Problem: Did you develop SSIS package using SSIS PowerPack components or native SSIS and now you like to upgrade to higher version and not sure how to do?
Solution: From Visual Studio 2015 Microsoft started unique approach so you just need single Visual Studio to test/design SSIS Package which could target SQL Server 20012 to 2017 (or later e.g. 2019).
Also, you can now Upgrade SSIS Package to a Higher version or Downgrade SSIS Package to lower version without any change. Downgrade SSIS Package was not possible in the previous version of Visual Studio.
Targeting SSIS Version in Visual Studio 2015 , 2017, 2019
- Launch Visual Studio 2015 / 2017 (or higher).
- Create or Open your existing SSIS Solution.
- In the solution explorer, Right click on the SSIS Project Node and click Properties (This node may be one level below solution node as below screenshot).
- When you see Properties select Configuration Properties. You will see TargetServerVersion , change that to other version click Yes if you see warning of Downgrade / Upgrade and then Click OK.
SSIS PowerPack Tasks