SQL Jobs and SFTP issue

• g.sree.devi

  SSC Journeyman

  Points: 91

  More actions

  October 31, 2009 at 12:22 am

  #135900

  We are using WINSCP.exe to download data file from SFTP. Following script used in the batch file :-

  open sftp://<<username>>:<password>>@<hostname>>:22

  The SSIS package works fine when we start the package manually.

  But when we try to schedule as a job we are getting the following error :-

  Error: 2009-10-31 00:18:23.26 Code: 0xC0029151 Source: Execute Process Task Execute Process Task Description: In Executing "C:\Program Files\WinSCP\WinSCP.exe" "-script=D:\ODS\ULTISCRIPT.txt" at "C:\Program Files\WinSCP\", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:18:21 AM Finished: 12:18:23 AM Elapsed: 2.266 seconds. The package execution failed. The step failed.

• parameshwari.vasanthakumar

  SSC Enthusiast

  Points: 116

  More actions

  February 26, 2010 at 2:59 am

  #1125450

  Problem:

  I need to send a file from my server to other server using SFTP.

  I have included sftp script in a.cmd file and added an "execute process task" in a DTS. But when ever I run the DTS either through designer, or through a SQL job , the SFTP step gets failed and gives "Connecting to Host failed"

  error.

  In my server SSH tectia Server and SSH Tectia Client is installed.

  I have accepted the public host key for that destination server in interactive mode(through command prompt).

  When I run the script seperaeltyoutside DTS, file is sent to the destination. But when used as a step in DTS, it fails abruptly. Please help to get rid of this problem as it is going bad....

  I have tried changing the ownership of DTS, but still it is not working.