mahesh.yerragonda (3/24/2014)
Hi,I created proxy login for user and created job to run the package.
below is the error im gettng.
"Description: Failed to decrypt protected XML node "DTS:Password" with error 0x80070002 "The system cannot find the file specified.
". You may not be authorized to access this information. This error occurs when there is a cryptographic error."
What is the protection level of the package?
I guess this is EncryptSensiviteWithUserKey. Change this to either DontSaveSensitive or to EncryptSensitiveWithPassword.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP