ssisvisual-studio-2015sql-server-2014vsta

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

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?

Solution

  • 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.