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
[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