Deployment problem with protection level

Hi all,

I have a problem while trying to deploy my packages that are configured in ProtectionLevel=EncryptSensitiveWithUserPassword

I use the Deployment Utility to deploy my packages. I set the password when deploying and the deplyment works fine. But I run the packages I have the following error : " Failed to decrypt an encrypted XML node because the password was not specified or not correct."

Did I miss something ?

Why not use protectionlevel = 'DontSaveSensitive"?|||

Because I'm deploying to a Test Environment and the Data on the Test Env are different so sometimes I would like to debug on the Test Env which means I load the package in BIDS.

What's wrong about using EncryptSensitiveWithUserPassword ?

|||

Sbastien Nunes wrote:

Because I'm deploying to a Test Environment and the Data on the Test Env are different so sometimes I would like to debug on the Test Env which means I load the package in BIDS.

What's wrong about using EncryptSensitiveWithUserPassword ?

Are you providing the password when executing the package? you have to provide password each time you execute the package. See Setting the Protection Level of Packages

I don't think there is nothing wrong with using EncryptSensitiveWithUserPassword; it's just that it adds and extra step to the deployment process making it more prone to error. If you use a combination of DonSaveSensitive as protection level with package configurations things get simpler; and you still will be able to debug o any environment.

I am suggesting the DonSaveSensite option; because that is what I use and I know it works I have never used EncryptSensitiveWithUserPassword.

|||

Well yeah you can still debug but you have to open each package to set the sensitive data back as they were removed when saved with ProtectionLevel=DontSaveSensitive

Indeed I'm not providing the password when the package is called for execution. I thought I had to give the password only when I open the package not when I run it. I'll fix that. Thanks for your help.

It's not very clear in BOL! They are talking about providing a password each time the package is loaded in BIDS but when talking about running the package it's not clear if they are still talking about executing the package within BIDS or outside.

sql