May 10, 2010 at 10:51 am
Team,
one of my ssis package was failing with below error,any help is appreciated
Executed as user: xxxx\SQLService. ...5.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:57:29 AM Error: 2010-05-10 09:57:29.94 Code: 0xC0016016 Source: Description: 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. End Error Error: 2010-05-10 09:57:29.97 Code: 0xC0016016 Source: Description: 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. End Error Error: 2010-05-10 09:57:46.75 Code: 0xC0202009 The package execution fa... The step failed.
May 10, 2010 at 11:49 pm
Check the following link if it helps
May 12, 2010 at 1:59 am
i was the same prob. and i changed the protectionlevel from SSIS to EncryptSensitiveWithPassword.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply