SQL 2005 DTS package to FTP

Other SQL Server Topics
1

I am working with an old DTS package. I know it is old school but it is the only tool I have to use. I am trying to set up my DTS package to FTP and I can get it to connect to the site using FileZilla, but I cannot figure out how to add the password to the connection string.

I set up an "Execute Process Task" and my parameter string is: sftp://user@ftpsite.com

Can someone tell me how to add the password to the connection string so it will pass it on?

2

Check this thread Problem configuring FTP Task

1 Like