问题描述
我正在创建一个使用脚本任务(通过 WinSCP)将文件上传到 FTP 的 SSIS 包.
I'm creating a SSIS package that uses a script task (via WinSCP) to upload a file to an FTP.
上传工作正常，但是如果没有上传文件，我需要该过程失败(目前它只是循环并通过成功) - 没有任何运气获得在 WinSCP 命令文件中编写脚本的帮助.
The upload works fine, however I need the process to fail if there is no file uploaded (currently it just loops through and passes a success) - Haven't had any luck getting help on scripting it in the WinSCP command file.
option batch on
option confirm off
open ftps://username:password@ftpsaddress/ -implicit -certificate="xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx"
cd "/DIR/"
option transfer binary
put \SERVERReports_BackUpSFTP*.csv -nopermissions -nopreservetime
close
exit
所以我的逻辑是在进程任务运行之前建立一个预运行文件检查进程.文件名变化很大，但它始终是 .csv.这就是我被困的地方.我需要添加一个任务来检查 .csv 文件是否存在，然后在此基础上传递失败或成功.
So my logic is to build a pre-run file check process before the process task runs. the file name varies greatly however it will always be a .csv. This is where I'm stuck. I need to add a task in that checks that a .csv file is there and then pass a fail or success on that basis.
推荐答案
假设 SSIS 监视进程退出代码，您可以使用 option failonnomatch on:
Assuming SSIS monitors process exit code, you can make WinSCP return exit code 1 by using option failonnomatch on:
option failonnomatch on
put ...
这篇关于当使用 WinSCP 选择要上传到 FTP 服务器的文件的掩码不匹配任何文件时，SSIS 任务失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！