Decrypt SSIS node password

Question

I have an SSIS package that I want to run from a WCF service. And I want the password stored inside the package. In the project, I set ProtectionLevel to EncryptSensitiveWithPassword and added the password for the package and project. All is good so far. The problem occurs when I try to execute a package from a service. It throws 2 errors, saying that it cannot decrypt the encrypted XML node because the password was not specified or is incorrect. I added the password for the package this way

 package.PackagePassword = password; 

Subsequently, he told me that the login failed for the user (which I consider obvious, since he was unable to decrypt the node password), and execution stops.

The reason I want to do this is not to manually edit the .dtsx file and add a password to connect.

I also own the package (I read that this can be a problem with this, when the user who created the package does not match the user who runs it, and I double-checked the password and protection level, and the password is correct, and the protection level is not set to EncryptSensitiveWithUserKey .

Any tips on how to proceed?

Answer 1

After much research, I came to the conclusion that this approach simply will not work. Therefore, for anyone who is interested in saving the password for the connection inside .dtsx , just save the package with DontSaveSensitive and manually add the password to the connection string of the package.