I have an SSIS package that is failing on a Script Task with this error message:
Failed to migrate scripts contained in the package to the VSTA 15.0 format.
This package was running fine on SQL Server 2012. But we recently upgraded to SQL Server 2019 and when I deploy this package to this new server, I get the above error message. This package is deployed from Visual Studio Professional 2015.
Has anyone seen this error before. I Googled this error but the discussions I found are very confusing. Would someone be able to help me figure this out. Thank you in advance.
Had the same problem. You have to change the TargetServerVersion to the version of SQL Server you are running.
Configuthe VS Solution explorer, R-Click on the project and select 'Properties'. Under on Properties of the solu> General need to change the TargetServerVersion to 2019.SQL Server; if that is the version of SQL You are running.