What is this error message and how do you fix it? I had a script task in one of my SSIS packages and when I deployed it and tried to run it I received this message:
Load multiple Excel Tabs:Error: There was an exception while loading Script Task from XML: System.Exception:
The Script Task "ST_9a61fb4231de4386a89bc7783e2f024b" uses version 15.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 is what shows up in my log.
You can also get the log messages by looking in the catalog.event_messages table like below.
This is caused by the SSIS package settings being higher than the target database actually is. My database is SQL Server 2016, but if you look in the properties of my solution, it shows that it is being deployed in SQL Server 2017 as a target version.
To fix, click the drop down and select the correct version of SQL Server that you are deploying to. Below I change it back to SQL Server 2016.
You should get this warning message. I clicked Yes to make the change.
Then I clicked Yes to all to reload the solution since we changed the setting above.
I then saved, and redeployed the solution and after rerunning the package, it now runs successfully.
I am still not sure why this happens, but for me it happens whenever I use a SSIS Script task. I also have SSDT 2015, and Visual Studio 2017 installed. More than likely the 2017 install is over riding some of the SSDT 2015 settings.