执行流程任务-SSIS作业失败 [英] Error at Execute process task-SSIS job fails

问题描述

我正在通过SSIS代理作业调用winscp.exe.当我通过winscp命令提示符运行脚本时，该作业就像一个超级按钮一样工作.如果我通过SSIS运行该脚本，则在计划该作业时将失败.

错误正在得到的是:

执行过程任务时出错:0xC0029151，执行过程任务时出错:在执行"C:\ Program Files \ winSCP \ winscp422.exe"中，在"\\ mylocalservername \"中，-script = \\ mylocalservername \ Batch.txt"，过程退出代码为"1"，而预期为"0".


以下是SSIS中的参数:，"-script = \\ mylocalservername \ Batch.txt"

我的脚本如下:

上的选项批处理 选项确认关闭
打开sftp://User:Password @ Server:22
将\\我的本地文件路径/远程服务器目录/
关闭
exit

I am calling the winscp.exe via an SSIS Agent Job. The job works like a charm when I run the script through a winscp command prompt.If I run it through SSIS it fails when I schedule the job.

And the error am getting is:

Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "C:\Program Files\winSCP\winscp422.exe","-script=\\mylocalservername\Batch.txt" at "\\mylocalservername\", The process exit code was "1" while the expected was "0".


The following are the arguments in the SSIS: ","-script=\\mylocalservername\Batch.txt"

My script is as follows:
option batch on
option confirm off
open sftp://User:Password@Server:22
put \\my local file path /remote server directory/
close
exit

推荐答案

不确定该问题，但快速谷歌搜索给出了以下两个看起来很有希望的链接.试试看.希望对您有所帮助.

链接1 [链接2 [ ^ ]

Not sure regarding the issue but quick googling gives below two links which looks promising. Try it out. Hope it will be helpful.

Link 1[^]

Link 2[^]

这篇关于执行流程任务-SSIS作业失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！