title: Decrypt SSIS password node
body: <p>I have an SSIS package that I want to execute from a WCF service. And I want the password to be stored inside the package. In the project I've set the <code>ProtectionLevel</code> to <code>EncryptSensitiveWithPassword</code> and added the password for the package and project. All good so far. The problem happens when I try to execute the package from the service. It throws 2 errors saying that it cannot decrypt the encrypted XML node because the password was not specified or is not correct. I've added the password for the package like so</p>
  
  <pre><code>package.PackagePassword = password;
  </code></pre>
  
  <p>Afterwards it's telling me that the login failed for the user (which I think is kind of obvious since it failed to decrypt the password node) and the execution stops.</p>
  
  <p>The reason I want to do this is to avoid having to manually edit the <code>.dtsx</code> file and add the password for the connection.</p>
  
  <p>Also I'm the owner of the package (I've read that it might be a problem with this when the user that created the package is not the same as the user who executes it, and also I've doubled checked the password and the protection level, and the password is correct and the protection level is not set to <code>EncryptSensitiveWithUserKey</code>.</p>
  
  <p>Any advice on how to proceed?</p>