SSIS with UNC

Advertisement

JsonTerre
Joined:
Posts:
1
Location:
Buffalo

SSIS with UNC

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

Reply with quote

Advertisement

You can post new topics in this forum