FTP Task Help

Question

FTP Task Help

Apollo74x

Ten Centuries

Points: 1250
More actions
December 12, 2006 at 11:29 am

#115601
Hi,
I can't connect to the FTP site using FTP task. As soon as I exit the FTP Manager, the supplied password disappears. Here is what I've tried based on a few threads that I've read regarding this issue:
1. Setting the protection level to "EncryptSincetiveWithPassword" and adding a password to the properties - failed with the same error.
2. Setting the password protect level to Don't Save Sensitive.
3. Checking in at msdn.com (to no avail which is why I came back here)
4. Transferring the data from a table to a network drive, then using Execution Process to run a ftp batch script which handles the transfer from a network to an FTP site. This almost works but http://ftp.exe begins to hang, then the file that is transferred over ends up being empty.
If someone can help me out here it would be much appreciated.
Thanks,
James

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ches Weldishofer Mr or Mrs. 500 Points: 512 More actions · Answer 1

When you deploy your package... make sure to click the checkbox that says depend on server for security. You're losing your password because of the security settings on the package.

You set it to Don't save sensisitive so it's not.

We use the default (which I believe is save with userKey) but then deploy with rely on server. that seems to make it all work.

Apollo74x Ten Centuries Points: 1250 More actions · Answer 2

This is working now. I was trying to set my security settings from the actual package withing Business Intelligence Solutions. I finally noticed the greyed out security settings on the package import screen. Once this part was set, it worked.

Thank you