Search code examples
sql-serverssiswinscp

Execute SSIS package is not working with SQL Agent


I post this question to the other forums too but still cannot find any solution. I create SSIS package to send file to SFTP server. It works fine when I execute the package with in the SSIS. But when I tried to run via SQL agent it keeps on running without sending the file until I stops the job by force. I add the proxy account too but no solution. My script to run the package is

option batch on 
option confirm off 
open sftp://UserName:Password@SFTP server Name :22001 -timeout=240
cd ToAA
option transfer binary 
put C:\test29022016.csv
mget *.csv
Exit WinSCP 
close
exit

Kindly help to solve this issue

Attached find the SSIS package details: enter image description here

SQL server credentials: enter image description here

SQL Process Keeps on Running: enter image description here

SQL Job: enter image description here

SQL enter image description hereCredentials:


Solution

  • I found a work around and I am using windows task scheduler with the help of batch file to run SSIS.