Executing batch file from SSIS

sorry for the typo...it is Execute process task which executes the batch file

Is there any info in the SQL Agent job history for that job or does it just say that it is successful?

Check that your SQL Agent account or proxy account that you are using has access for both FTP and copying the files.

Are you using a Windows account for SQL Agent?  Can you login to the server where these are running with the Windows account and see if you can run the package?

Hi Greg,

Thanks for the reply. Job history just shows that job ran successfully. I would like to elaborate more on the problem. I have got SSH client installed in the server and I generated the SSH User keys with my windows login which is then uploaded to SSH server. Now when I run the package (I am the owner of the package) using BIDS , the files are transferred. But when I schedule it to run with "sa " as the owner and running the package under default SQL Agent service account, the files are not getting transferred. I tried running the package with my windows login as well but to no avail. I truly appreciate your help on this.

Thanks in advance

Beeram