When and why does this error message appear..
Error 1 Error loading MasterPackage.dtsx: Failed to decrypt protected XML node "PackagePassword" 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.
are you using package configurations? if so , how are they being stored (db, XML file ect.)
what is your ProtectionLevel set to on your package properties?
how is the package being run? (debug, SqlAgent, execcute w/o debug , command line ect.)
|||I have a master package which is calling other packages...I just opened to set some package configuration but did not set and then it's coming out with this message when i try to open my master package but is running fine even if comes out with this message...
|||what is the ProtectionLevel property set to on the children and parent? Right click properties -> ProtectionLevel)
it appears that when you are opening the package it cannot decrypt the sensitive information.
This often occurs when developing on one box and promoting to another.
|||my protection leve is set to EncryptSensitiveWithUserKey on both parent and child.
|||As Ryan wrote, this error may occur when moving from one box to another - this protection level uses Windows Data Protection API (DPAPI), which automatically encrypts secrets with user key, but is limited in that it obviously allows only original user to decrypt secrets, and (less known) it only works on original computer only, unless you are using Roadmin Profile.If you need to move packages to other computers, or execute them under different user account - use other protection levels. See Books Online for details.
No comments:
Post a Comment