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://firstname.lastname@example.org
Can someone tell me how to add the password to the connection string so it will pass it on?