September 7, 2012 at 7:19 am
I have a package that runs fine in development. But when I run it in a job, I get this error:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:02:12 AM
Error: 2012-09-07 09:02:12.72
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTS:Property" 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: 2012-09-07 09:02:12.99
Code: 0xC0010026
Source: BizCrypto OpenPGP Protect Task
Description: The task has failed to load. The contact information for this task is "EldoS Corporation".
End Error
Error: 2012-09-07 09:02:12.99
Code: 0xC0024107
Source: BizCrypto OpenPGP Protect Task
Description: There were errors during task validation.
End Error
Error: 2012-09-07 09:02:12.99
Code: 0xC0010025
Source: McFina_Branch
Description: The package cannot execute because it contains tasks that failed to load.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 9:02:12 AM
Finished: 9:02:12 AM
Elapsed: 0.438 seconds
I have tried all the DTS protection levels. The package does need to pull from a server file location.
I don't think it has to do with the edios pgp container..but..I don't know for sure.
Thanks in advance for any help offered.
September 13, 2012 at 12:39 pm
I think you are using a third party task called BizCrypto OpenPGP Protect Task. It has to do with that. Please ensure the respective keys for encryption / decryption are registered on the server where the encrypt / decryp stuff is happening(in this case it is the machne you are trying to run the SSIS on)
September 13, 2012 at 10:34 pm
The error message says
You may not be authorized to access this information.
I believe it is due to permission issue.
Use Proxy Account for the job.
September 14, 2012 at 9:09 am
The below is yopur error :
Failed to decrypt protected XML node "DTS:Property" 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.
Clearly it is to do with the key file either not being available at the right location or the key not being registered on the machine.
BizCrypto OpenPGP Protect Task is from teh company called ELDOS. You can look for help with this specific task there.
your error msg also, btw, says it is in that task.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply