I have another developer who was developing an SSIS package locally on his machine, and when I tried to open the package and run it on my machine, I get the following error messages
Failed to decrypt protected XML node "DTS:Password" 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.
Any ideas on how to resolve this one, as I dont want to go through the process of developing the package on the server, to avoid issue like this. Any help would be appreciated.