在SSIS中执行批处理脚本 [英] Executing Batch script in SSIS

问题描述

我有一个SSIS包，我要在其中执行批处理脚本.问题是，当我在包本身中手动执行它时，它们运行起来都很流畅.但是，如果我在SSMS中设置了一个作业并从那里运行该作业，它将一直运行，并且永不停止.缺点是没有错误消息，这使得调试更加复杂.

I have a SSIS Package, in which I want to execute a batch script. Thing is that it all runs smooth when I execute it manually in the package itself. However, if I set up a job in SSMS and run the job from there, it just keeps running, it never stops. The downside of that is that there is no error message, which makes debugging this more complex.

我知道对于大多数人来说，根据此信息绝对不可能回答.我想我希望有人经历过同样的事情，并且以某种方式找到了解决方案.

I know for most people this is absolutely impossible to answer based on this info. I guess I am hoping that someone has experienced the same thing and somehow found a solution.

非常感谢！

问候，M.

推荐答案

不确定(距离我接触SSIS至少一年了)，但我似乎记得您需要确保脚本返回一个ExitCode，其中0表示成功.

Not completely sure (been at least a year since I've touched SSIS) but I seem to remember that you need to make sure that the script gives back an ExitCode, where 0 means success.

所以最后一行可能是:

exit 0

这篇关于在SSIS中执行批处理脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！