Topic "ssis 2005 sftp winscp"

Author Message
nz

Guest


I am using a ssis 2005 to do some sftp tasks using winscp. I googled it a bit but couldn't make it work. I got this error: [Execute Process Task] Error: In Executing "C:\Program Files\WinSCP\WinSCP.exe" "-script=C:\Documents and Settings\nian_z\Desktop\temp\SSISMovingSOA\removeSOA8.txt" at "C:\Program Files\WinSCP", The process exit code was "1" while the expected was "0".

Here is my winscp script used:

option batch abort
option confirm off
#open sftp://user:password@server:22
#cd /m/vo/Cont/fileftp
get OrderOutbound*
close
exit

For above script, I even tired leaving only one statement at a time, but still got error.
nz

Guest


all right, i got it solved. here is the thread i posted in stack overflow.
http://stackoverflow.com/questions/14727900/how-to-fix-exit-code-issue-while-using-winscp-for-sftp-from-within-ssis-package
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