The Script Task Uses Version 15.0 that is not supported in the release of integration services

Question

My team is planning to move from SQL Server 2014 to 2016. Currently, SSIS package is created in VS 2013 and deployed on SQL Server 2014. For testing i tried to deploy the package in SSMS 17.3 (Integration services 13.0). The package is successfully deployed but when i try to validate the package, the get the following error:

After reading some solutions on the internet, I deployed the package from the following path:

%ProgramFiles%\Microsoft SQL Server\130\DTS\Binn

The package was successfully validated (without modifying ispac file). As per my understanding, the script task is created with VSTA major version 15 in VS 2017. I tried to open the solution in VS 2015 and rebuilt the solution with SQL server 2017 as target server. Before deploying the package on SSMS 17.3, I made sure that the dtsx file contains 15 VSTA major version.

After verifying, i deployed the package on SSMS 17.3 which is using the following path:

%ProgramFiles%\Microsoft SQL Server\140\DTS\Binn

I validated the package but i got the same error. As per my understanding, if i build the solution by selecting SQL server 2017 as target version, it should be successfully validated. How can i resolve this issue if i want to use SSMS 17.3 for deployment?

Answer 1

In my case the Target Server Version was set to 2017. I updated it to 2016 and it worked.

Answer 2

After searching for a while on this issue, it looks like this is a common issue of SSMS 17.x you must install 16.x versions to avoid this error or deploy with SQL Server 2016 deployment tools (Microsoft SQL Server\130\DTS\Binn) as you mentioned:

For more information, read the discussions below, they contains very helpful

• SSMS 17.3 and VS 2015 deployment issue
• Difference between .ispac and SSDT deploy