Hello All -
I am upgrading a ton of SSIS packages from 2008 R2 to 2016. The problem is that whenever I run the packages in a job to test them I get an error that the script component task hasn't been upgraded. This also happens whenever I open a package which contains a script task (which is almost all of our packages, some 150 of them). The following steps are what i've done to upgrade the packages:
1) Created a new SSIS solution and set the version to SQL Server 2016
2) Added packages to the solution which then automatically upgrades them to 2016
3) I open the XML code and view the properties to verify that it is set to version 8 (which is 2016)
4) I'm setting the TargetFrameworkVersion to 4.0 - this translates to .NET 4.0
Both myself and my co-workers are confused as to why this is happening and how to fix it. Have any of your encountered this problem before?