May 14, 2009 at 6:43 am
Hi
I developed a package with ssis 2008. This package has 6 "execute package task". everyone of them call a different dtsx.
when i start that package from ssis utility, it works and give me no errors
when i start thath package from a job scheduled on sql server agent, it works the same but i received an error at the end of execution.
The same mistake happen in another project of mine but with ssis 2005 and sql server 2005
error message is:
Message
Executed as user: SIMPNRSVILDB2\SYSTEM. ....0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:29:24 PM Error: 2009-05-13 15:29:26.14 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: 2009-05-13 15:29:26.16 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: 2009-05-13 15:29:30.56 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: 2009-05-13 15:29:30.66 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: 2009-05-13 15:29:39.08 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: 2009-05-13 15:29:39.21 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: 2009-05-13 15:29:46.60 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: 2009-05-13 15:29:46.69 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: 2009-05-13 15:29:54.83 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: 2009-05-13 15:29:54.92 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: 2009-05-13 15:30:02.97 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B ... The package execution fa... The step failed.
Thank you and sorry for my bad english...
May 14, 2009 at 9:07 am
This is usually the result of executing the package as a different login than the one that created the package. When you run the package in BIDS, you're running it as yourself and when it runs in a job it's running as the SQL Agent account.
Check the ProtectionLevel property of the package and save the package with the ProtectionLevel set to something other than "Encrypt...WithUserKey" because that would mean only you can execute the package.
Greg
May 14, 2009 at 9:46 am
Indeed i don't need to encrypt sensitive... But my job has multiple steps, every step call a dtsx (saved on filesystem) with the same protection level (EncryptSensitiveWithUserKey), but i receive the error only with the package that call other packages using "execute package task"... and especially i don't understand why the step works fine but at the end raise the error
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply