Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”

TITLE: Microsoft Visual Studio
———————————————

There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.

———————————————
BUTTONS:

OK
———————————————

Error    1    Error loading xyz.dtsx:
Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”.
You may not be authorized to access this information.
This error occurs when there is a cryptographic error.
Verify that the correct key is available.
D:\Database\Packages\SSIS\xyz.dtsx    1    1

Issue:-

We had this error on opening an SSIS package in VS/BIDS and runnin it via a scheduled job; The SSIS package was migrated from an old sql server 2005 to new SQL Server 2008 R2 server.

Cause:-

This happens because of the package protection level which is by default set to “EncryptWithSensitiveKey”.

Resolution:- Setting the package protection level to “DontSaveSensitive” helped us to resolve these errors.

How to Change the SSIS Package Protection:

In Business Intelligence Development Studio, open the Integration Services project that contains the package.
Open the package in the SSIS designer.
If the Properties window does not show the properties of the package, click the design surface.
In the Properties window, in the Security group, select the appropriate value for the ProtectionLevel property.

If you select a protection level that requires a password, enter the password as the value of the PackagePassword property.
Save and Close the Package and execute successfully.

This entry was posted in SQL Server, SSIS, Troubleshooting and tagged , , , , . Bookmark the permalink.

4 Responses to Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”

  1. Howdy excellent website! Does running a blog similar to this take a massive amount work? I’ve very little expertise in programming but I had been hoping to start my own blog in the near future. Anyhow, if you have any suggestions or techniques for new blog owners please share. I understand this is off topic but I just wanted to ask. Kudos!

    • Suleman says:

      Hi Paul,

      Thanks for visiting my blog; Blogging is not difficult at all, and you don’t really need to know technical details; there are a lot of instructional videos on youtube.com if you want, search for ” create a wordpress blog ” and you will find hosts of videos detailing each and every step;

      Firstly you will need to have a domain name and hosting space; visit http://www.hosting-direct.org.uk; where I provide low cost hosting solutions for any need. once you have your hosting space; I can help you setup the blog quickly and I wouldn’t mind giving you a demo on how to use it.

      Hope that helps.

      Regards,
      Suleman

  2. Pingback: My Homepage

  3. Pingback: dostana

Leave a Reply