August 21, 2009 at 8:10 am
After moving my package to a new server, I am getting an error relating to this issue:
"Error loading PackageName: 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."
http://support.microsoft.com/default.aspx?scid=kb;en-us;904800
I have changed the value of the ProtectionLevel property in the SSIS package and I still get this error. What gives?
August 21, 2009 at 8:43 am
I believe you are getting this error because the Source or Destination connections have passwords stored for them. Because you have moved the package to a new location, something may have become corrupted, e.g. connection string may no longer be correct.
If you open the connection managers and re-enter any passwords, then save, it should refresh itself.
Chris Fitzgerald 😀
August 21, 2009 at 8:54 am
I believe you are getting this error because the Source or Destination connections have passwords stored for them. Because you have moved the package to a new location, something may have become corrupted, e.g. connection string may no longer be correct.
If you open the connection managers and re-enter any passwords, then save, it should refresh itself.
Chris Fitzgerald 😀
August 21, 2009 at 9:07 am
Chris Fitzgerald (8/21/2009)
I believe you are getting this error because the Source or Destination connections have passwords stored for them. Because you have moved the package to a new location, something may have become corrupted, e.g. connection string may no longer be correct.If you open the connection managers and re-enter any passwords, then save, it should refresh itself.
Nope, doesn't work.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply