[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
option transfer binary
get *.txt \\MyUNC\C$\Data\FTP\Diamond
In my SSIS Execute Process Task I have the following:
Executable: C:\Program Files (x86)\WinSCP\WinSCP.exe
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.