TITLE: Microsoft Visual Studio
There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.
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
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.
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.