Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

JsonTerre

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