Display Processed
Day:Error: The Script Task is corrupted.
|
Display Processed
Day:Error: There were errors during task validation.
|
Display Processed
Day_disabled:Error: There was an exception while loading Script Task from
XML: System.Exception: The Script Task
"ST_31c133622a274959a9a421082b570cbf" 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) |
This error occurred after updating SSIS packages from
Visual Studio 2015 and deploy back to the SQL server 2014. I was able to
execute the packages successfully from Visual studio but when I execute from
SSMS it throws below errors.
I have noticed the SQL version selected as SQL 2016 for
these packages when I the project properties in VS 2015. Change it to SQL
Server 2014 or 2012 as same as your SQL Server version, build the project and deploy back to SQL Server to fix the issue.
Check below screenshot where you can find the above mentioned setting.
No comments:
Post a Comment