SSIS: script task (vs15) not work when deploy on sql server 2014

Question

The error:

There was an exception while loading Script Task from XML: System.Exception: The Script Task uses version 14.0 script that is not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases, scripts are converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_PRODUCT_SHORT_NAME% Integration Services. at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj, IDTSInfoEvents events)

I'm doing exactly what it says, but it does not help.

Any solution?

Answer 1

This worked for me:

1. Install SSDT-BI for Visual Studio 2013.
2. Open your solution in Visual Studio 2015.
3. Select your SSIS Project in the Solution Explorer.
4. In the Project menu select Properties.
5. In the Property Pages dialog select Configuration Properties -> General
6. Under Deployment Target Version change the Target Server Version to "SQL Server 2014."
7. Clean and rebuild solution and redeploy.

Answer 2

In the revised version of the SSDT (now 14.0.61x), there is a fix.

1. Install new version. (SSDT For download)

2. Right click project > Properties > Configuration Properties > General > TargetServerVersion - Update to SQL Server 2014 > Redeploy.