password cannot be saved

Qiuwei


Hi, there;
I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..."

Did I do something wrong or anybody know how to save that password field

Cheers

JayH


The password in a SQL-authenticated connection is considered sensitive data. SSIS wants to encrypt any sensitive data in the package (see ProtectionLevel). By default it does this with your user key. Unless you've changed the ProtectionLevel, you should be able to save the package and reopen it (as the same user) and have it preserve your password. If you're going to be opening it from an application, your best bet for ProtectionLevel is probably to use the "EncryptSensitiveWithPassword" option, which uses a password to encrypt the sensitive data. The application (and any users) will need to supply this password when opening the package.

A good alternative to storing sensitive data in the package is to read the password into the package using a Package Configuration mechanism.

Qiuwei

Thanks.

Do you mean I need another password to open my package

Where can I set the "ProtectionLevel" in the package

Phil Brammer

See the link that JayH included.

Qiuwei

Thank you.

I will try.