'SSIS : Warning: Failed to decrypt an encrypted XML node

There are couple of questions similar to this (here). But here is my current situation -

  1. I wrote some SSIS packages a while back using a windows account domain1\first.lastname with the default protection level set to encryption by user key
  2. Now we all got migrated to a new domain domain2\first.lastname.
  3. So now whenever I open those packages I am getting this error -

Warning: Failed to decrypt an encrypted XML node. Verify that the project was created by the same user. Project load will attempt to continue without the encrypted information.

Is there a way to open these packages at all ?

xmlencryptionssis


Solution 1:[1]

Open your Project.params file. Enter your password(s) and change them to sensitive False. This will allow you to work and test in Visual Studio.

Read more about SSIS access control here: https://docs.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages?view=sql-server-ver15

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 TylerH

Related Questions