Topic "SSIS with UNC"

Author Message
[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 s
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

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.
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 26890
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:

You can post new topics in this forum


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!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License