How to change TargetServerVersion of my SSIS Project

If you are using SSDT for Visual Studio 2015 or Visual Studio 2017 then most likely your SSIS Packages are designed to target SQL Server 2017 by default. If you are not deploying SSIS Packages to SQL 2017 then you must change TargetServerVersion as below.

For SQL Server 2017 (vNext) - SSDT BI for Visual Studio 2015/2017 (Apr 2017 Update or later)

Note: Starting from Visual Studio 2015, Microsoft introduced authoring SSIS Packages for multiple versions (i.e. Same Visual Studio version can be used to edit packages for 2012, 2014, 2016, vNext). Also, you can Upgrade or Downgrade SSIS package format in few clicks (see below steps)

1. Install SSIS PowerPack.
2. Launch Visual Studio 2015 or 2017. Create or Open your existing SSIS Solution.
3. 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).
4. When you see Properties select Configuration Properties. You will see TargetServerVersion change that to other than vNext and click Yes if you see warning of Downgrade and then Click OK. 
   

Reference http://zappysys.com/onlinehelp/ssis-powerpack/scr/getting-started.htm

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/