December 19, 2010 at 7:27 pm
Dear All,
One of our left out developer has written this package when i tried to open the package i am getting the below error.
Error1Error loading Atlantis_Import 2.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.
Please help me to resolve with the issue.
Thanks,
Gangadhar
December 19, 2010 at 8:24 pm
The reason for this is by default SSIS packages are saved with the "EncryptSensitiveWithUserKey" option. This ensures that the package is encrypted with the credentials of the user creating it. Please change the Encryption level of the package to something like "EncryptSensitiveWithPassword" and save it. More details here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply