x

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?
more ▼

asked Sep 03, 2010 at 08:01 AM in Default

marobins gravatar image

marobins
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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
more ▼

answered Sep 03, 2010 at 11:03 AM

Oleg gravatar image

Oleg
15.9k 2 4 24

Sorry, I don't see the option to save it with EncryptSensitiveWithPassword. Thanks, Mark
Sep 03, 2010 at 12:42 PM marobins
@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
Sep 03, 2010 at 10:26 PM Oleg
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
Sep 04, 2010 at 05:06 AM Daniel Ross
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x943

asked: Sep 03, 2010 at 08:01 AM

Seen: 2586 times

Last Updated: Sep 03, 2010 at 08:55 AM