Pages

Sep 13, 2017

Display Processed Day:Error: The Script Task is corrupted.The Script Task "ST_31c133622a274959a9a421082b570cbf" uses version 14.0 script that is not supported in this release of Integration Services.

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: