CODEWITHSUNDEEP
xmlencryptionssis
anilit99
anilit99

Reputation: 597

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 ?

Upvotes: 8

Views: 30964

Answers (1)

user2354811
user2354811

Reputation: 81

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://learn.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages?view=sql-server-ver15

Upvotes: 8

Related Questions