SSIS脚本任务无法通过15.0版脚本执行? [英] SSIS script task fail version 15.0 script?

问题描述

我有一个在SQL Server 2016上运行的2012 SSIS项目.我的开发机和服务器上都有SSDT 2015.除脚本任务外，其他所有东西都正常运行-我对现有脚本任务进行了更改，然后重新构建并重新部署了项目，并且收到以下错误消息:

I have a 2012 SSIS project that runs on SQL Server 2016. I have SSDT 2015 on both my dev machine and server. Everything works fine except for script tasks - I made a change to an existing script task and rebuilt and redeployed the project and I receive the following error:

脚本任务使用此集成服务发行版中不支持的15.0版脚本.要运行该程序包，请创建一个新脚本.

Script task uses version 15.0 script that is not supported in this release of integration services. To run the package, create a new script.

我尝试了以下操作:

• 将项目升级到2016年
• 创建一个新的脚本对象
• 在服务器上创建脚本

它在SSDT 2015上运行良好，但是一旦通过SSMS执行程序包，则部署失败并出现上述错误-这是我的开发箱和服务器的结果.我以为14.0是2016?有什么想法可以解决这个问题吗?

It runs fine through SSDT 2015, but once it is deployed it fails with the error above when executing the package via SSMS - this is the result from both my dev box and the server. I thought 14.0 was 2016? Any ideas how I can fix this?

脚本任务(在包中)不能通过服务器上的集成服务目录执行，但在SSDT中可以正常工作.

Script tasks (in packages) cannot be executed via integration services catalog on server, but work fine in SSDT.

推荐答案

这对我有用.如果您使用SSMS并尝试通过Integration Services目录(导入和部署)添加DTSX(包含脚本)，它将失败.但是，如果您在Visual Studio中使用Project> Deploy选项，它将成功.我的目标是SQL 2016，SSDT是2015.请注意，在Project下是我使用的Upgrade All Packages选项.我不知道这是否有必要，我认为不是，但以防万一.

Here is what worked for me. If you use SSMS and try to add your DTSX (which contains a script) via Integration Services Catalog (Import and Deploy) it will fail. However if you use the Project>Deploy option from within Visual Studio it will succeed. My target was SQL 2016 and SSDT is 2015. Note that under Project is a Upgrade All Packages option which I used. I don't know if this is necessary, I don't think so, but just in case.

这篇关于SSIS脚本任务无法通过15.0版脚本执行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！