October 31, 2009 at 12:22 am
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.
February 26, 2010 at 2:59 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply