Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-05-10 : 12:49:48
|
| Team,one of my ssis package was failing with below error,any help is appreciatedExecuted 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-10 : 14:17:52
|
| what was protection level selected for package? was it created by you and executed under same user id?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-05-10 : 14:21:24
|
| i have not created it,can you tell me how to edit this and set protectionlevel,as i dont have idea on ssis |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-10 : 14:40:21
|
| i think it was created with protection level encrypt all information with password. then package can be decrypted only by providing that password. check with creator what was setting used for protection level------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
ssis pack failure