Do not think working directory matters as long as you use absolute path everywhere, what you seem to do. On the order hand, I'm not sure that working directory can be UNC path.

Also please read:
https://winscp.net/eng/docs/faq_scheduler
https://winscp.net/eng/docs/faq_exit_code

I am getting this error and I simply have no idea why. Can anyone help?

[Execute Process Task] Error: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "-script=\\MyUNC\C$\Data\MyFile.txt" at "\\MyUNC\C$\Data\FTP\Diamond", The process exit code was "1" while the expected was "0".



the script file is


option batch on
option confirm off
open sftp://username:pass@ftp.foo.com:22
cd
option transfer binary
get *.txt \\MyUNC\C$\Data\FTP\Diamond
close
exit


In my SSIS Execute Process Task I have the following:

Executable: C:\Program Files (x86)\WinSCP\WinSCP.exe

Arguments: \\MyUNC\C$\Data\MyFile.txt

WorkingDirectory: \\MyUNC\C$\Data\FTP\Diamond

not sure i need WorkingDirectory but this is where I think the issue is. I leave it balnk or add the same UNC as in the script and I get the same error. [at "\\MyUNC\C$\Data\FTP\Diamond"] with value entered and [at ""] woth no value entered.


Thanks in advance.
jason