Hi Tim,

The scripts are in the same server location where I am running the scripts.

Such as I have placed the scripts under E:\APPS\.. of the server.

And referred the same path...

Hi Tim,

Thanks for the post.

When I run my batch script manually it is getting executed successfully, problem is when I automate the same script in a DTS (SQL Server 2000),...

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....

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....