SSIS 执行进程任务挂在 SQL Server 作业中，没有给出错误 [英] SSIS Execute Process Task hanging from SQL Server Job, no errors given

问题描述

我有一个基本的 SSIS 包，它有一个执行进程任务，它运行一个 .exe，它位于我们的 NAS/共享驱动器上，它生成一个 csv 文件并由后续步骤读取.

I have a basic SSIS package that has an execute process task which runs a .exe sitting on our NAS/Share drive which produces a csv file and is read by later steps.

我可以在 BIDS 中执行 SSIS 包，并且一切正常.当部署到服务器并从作业运行时，SSIS 包只是挂起并保持在执行模式.

I can execute the SSIS package within BIDS and everything works flawlessly. When deploying to the server and running from job the SSIS package just hangs and stays in executing mode.

为了验证我们可以从服务器运行它，我尝试从服务器内的命令行运行 .exe 并遇到一个错误，导致 .exe 停止运行，结果我们需要一个 64 位的 Windows Server 2008我们放在一起的特定 .exe.尽管更新了 .exe 并能够从服务器中的命令行运行它，但我们仍然遇到同样的问题.

To verify we could run it from the server, I tried running the .exe from the command line from within the server and came across an error which was stopping the .exe running, turns out we needed a 64bit, windows server 2008 specific .exe which we have put together. Despite updating the .exe and being able to run it from the command line in the server now we are still suffering the same issue.

任何想法、指示，甚至潜在的研究途径都将不胜感激，因为我对 SSIS 相对较新，并且正在耐心地尝试破解它.

Any ideas, pointers, even potential research avenues would be greatly appreciated as I am relatively new to SSIS and am patiently trying to hack my way through it.

干杯

推荐答案

如果您从 UNC 路径使用可执行文件，则必须将其添加到本地 Intranet 的区域设置中.

If you are using your executable from a UNC path you will have to add it in the zone setting in Local intranet.

在您的 Internet Explorer 上，转到安全并选择本地 Intranet 设置.单击站点并添加您的 UNC 路径，然后单击确定.file://协议是自动添加的.

On your Internet Explorer, go to Security and select Local Intranet setting. Click on Sites and add your UNC path and click ok. The file:// protocol is added automatically.

这与 SSIS 无关，而与 Internet Explorer 中的区域设置有关.

This has nothing to do with SSIS, but everything to do with the zone settings in Internet Explorer.

这应该会有所帮助.

这篇关于SSIS 执行进程任务挂在 SQL Server 作业中，没有给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！