SSIS脚本任务错误部署到SQL Server 2019：未能迁移包含在软件包中的脚本到VSTA 15.0格式
我有一个带有此错误消息的脚本任务的SSIS软件包：
未能迁移软件包中包含的脚本到VSTA 15.0格式。
该软件包在SQL Server 2012上运行良好。但是我们最近升级到SQL Server 2019，当我将此软件包部署到该新服务器时，我会收到上述错误消息。此软件包是从2015年Visual Studio Professional部署的
。以前有人看过此错误。我搜索了这个错误，但是我发现的讨论非常令人困惑。有人可以帮助我解决这个问题。先感谢您。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有同样的问题。您必须将TargetServerververion更改为您正在运行的SQL Server版本。
Configuthe vs Solution Explorer，项目上的R-CLICK，然后选择“属性”。在Solu＆gt的属性下；一般需要将TargetServerververion更改为2019.SQL Server；如果那是您正在运行的SQL的版本。
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.