ssis with WINSCP

• clucasi

  SSCrazy

  Points: 2113

  More actions

  September 17, 2010 at 1:51 am

  #142696

  Hi guys

  I am having problems using Process task and WinCP

  in the executable box I have the following statement

  C:\Program Files\WinSCP\WinSCP.exe

  this seems to work fine

  the arguments are a different kettle of fish

  the statement I use is

  -script="C:\FTPS_exe.txt" ;

  the problem is that it doesn't seem to run the text file

  the text file is as follows

  pause

  option batch on

  option confirm off

  open mysession -hostkey="ssh-rsa 1024 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx"

  get /remotepath/data.dat c:\localpath\

  exit

  I also seem get the followinf error

  [Execute Process Task] Error: In Executing "C:\Program Files\WinSCP\WinSCP.exe" "-script="C:\FTPS_exe.txt" ;" at "", The process exit code was "1" while the expected was "0".

  Has anybody got any ideas

  Cheers

• HooRoo

  SSC Veteran

  Points: 210

  More actions

  September 28, 2010 at 2:04 am

  #1228185

  Hello,

  I think this was the result of a bug in WinScp 4.2.8

  which was resolved in version 4.2.9.

  Hope that helps,

  Helen