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
I found a work around and I am using windows task scheduler with the help of batch file to run SSIS.