question

marobins avatar image
marobins asked

SQL Server 2008 SSIS FTP Step Failing

I have an 2008 SSIS package with an FTP step. I enter the FTP info into the FTP Connection Manager and the package will execute successfully. However it will not retain the FTP password even after saving the package. Any ideas?
sql-server-2008ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered
Try to right-click on your **FTP Connection Manager** and choose **Properties**. Type your password and then, when you get to saving your package, save it with **EncryptSensitiveWithPassword** option. This is different from the default **EncryptSensitiveWithUserKey** option, which will, for example, fail to run your package when you setup a job, because the account is not going to be consistent with yours (the one used to create SSIS package). Oleg
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sorry, I don't see the option to save it with EncryptSensitiveWithPassword. Thanks, Mark
0 Likes 0 ·
@marobins I think I just found a great resource for your question on SSC site. It has 5 pages of discussions devoted to the same problem like you have. Here is the link: http://www.sqlservercentral.com/Forums/Topic278800-148-1.aspx
0 Likes 0 ·
Marobins, if you click on an empty space on the control flow then press F4 to bring up the properties of the package, there is a section on security. Make sure the package says EncryptSensitiveWithUserKey, then you will be able to keep the password in the FTP connection
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.