SSIS 脚本任务在服务器上失败，出现错误“无法加载执行脚本" [英] SSIS script task fails on server with error "Cannot load script for execution"

问题描述

我有 3 个带有脚本任务的 SSIS 包，它们都做非常相似的事情 - 查询 SQL Server 数据库，遍历结果，然后为每一行调用 SOAP 网络服务.这些包在本地运行良好，在开发和 QA 服务器上运行良好.

I have 3 SSIS packages with script tasks that all do very similar things - query a SQL Server database, loop through the results, and then call a SOAP webservice for each row. These packages run fine locally, and run fine on a development and a QA server.

在生产服务器上，1 次运行正常，2 次失败，并出现无法加载执行脚本"错误.这些是 Server 2008 SP2 上的 SQL 2008 R2 环境.无论运行它们的用户如何，都会发生错误.

On the production server, 1 runs fine and 2 fail with the ominous "Cannot load script for execution" error. These are SQL 2008 R2 environments on Server 2008 SP2. The error happens regardless of the user who runs them.

到目前为止，我已经尝试了以下方法:

So far I have tried the following:

• 在我的开发环境中运行包，数据库连接指向生产(运行良好)
• 在项目设置中将 Run64BitRuntime 设置为 false.没什么区别.
• 删除包并重新部署它
• 按照建议对/Windows/Temp 的显式写入访问权限 此处.最初在使用代理用户运行时确实发生了这种情况，因此我们尝试了此修复程序.但是我在使用我的管理员帐户运行时遇到了同样的错误.

• Run the package in my dev environment with the database connections pointing to production (runs fine)
• Set Run64BitRuntime to false in project setting. Made no difference.
• Deleted the package and redeployed it
• Given explicit write access to /Windows/Temp as suggested here. This did initially happen when running with a proxy user, sowe tried this fix. But I get the same error when running with my admin account.

我无法在生产服务器上重新编译脚本，因为开发堆栈不存在并且它是生产服务器.我也无法按照建议在此服务器上安装或更新 BIDS 此处.

I cannot recompile the script on the production server because the development stack is not there and it is a production server. I can also not install or update BIDS on this server as proposed here.

根据某些人的发现，似乎可能需要在目标环境上重新编译脚本，但我没有这个选项.

It seems that somehow it might be required to recompile the script on the target environment, based on what some people have found, but I don't have this option.

推荐答案

所以，很遗憾，答案是重建脚本任务.看来这些东西可能会损坏.我真的没有更改任何一行代码，只是重新创建了任务并从损坏的版本中复制了代码.

So, the answer is unfortunately to rebuild the script task. It appears that these things can get corrupted. I literally did not change a single line of code, just recreated the task and copied the code from the broken version.

这篇关于SSIS 脚本任务在服务器上失败，出现错误“无法加载执行脚本"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！