Topic "SSIS with UNC"

Author Message
JsonTerre
[View user's profile]

Joined: 2012-11-28
Posts: 1
Location: Buffalo
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
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
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
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License