Error at Execute process task-SSIS job fails

See more:

SQL-Server-2005

SQL

SQL-Server

, +

I am calling the winscp.exe via an SSIS Agent Job. The job works like a charm when I run the script through a winscp command prompt.If I run it through SSIS it fails when I schedule the job.

And the error am getting is:

Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "C:\Program Files\winSCP\winscp422.exe","-script=\\mylocalservername\Batch.txt" at "\\mylocalservername\", The process exit code was "1" while the expected was "0".


The following are the arguments in the SSIS: ","-script=\\mylocalservername\Batch.txt"

My script is as follows:
option batch on
option confirm off
open sftp://User:Password@Server:22
put \\my local file path /remote server directory/
close
exit