Menu
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?
889
VSTA is the scripting environment that SQL Server 2008 Integration Services (SSIS) uses. In SQL Server 2005, the scripting environment for Integration Services is Microsoft Visual Studio for Applications (VSA).
SSIS Script Task is an effortless task where not much configuration is needed. The initialize a Script task, the user must specify the programming language to be used, the read-only and read-write variables. Two programming languages are supported in the SSIS Script task: Visual Basic . NET and C#.
SSIS allows the developer to choose between two different scripting languages: C# or Visual Basic (VB). To see where you can make this choice, drop a Script Task onto the Control Flow design surface.
Open your solution in Visual Studio 2015. Select your SSIS Project in the Solution Explorer. In the Project menu select Properties. Under Deployment Target Version change the Target Server Version to "SQL Server 2014."
In SQL Server 2008 Integration Services (SSIS) and later versions, all scripts are precompiled. In earlier versions, you set a PrecompileScriptIntoBinaryCode property to specify that the script was precompiled. To learn more about the Script task, see Script Task and Configuring the Script Task in the Script Task Editor.
package validation failed with "The Script Task uses version 15.0 script that is not supported in this release of Integration Services..." The current SSDT version 17.1 provides a support to target SQL Server 2014 - SQL Server vNext.
Bookmark this question. Show activity on this post. 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.
This worked for me:
131
In the revised version of the SSDT (now 14.0.61x), there is a fix.
Install new version. (SSDT For download)
Right click project > Properties > Configuration Properties > General > TargetServerVersion - Update to SQL Server 2014 > Redeploy.
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
