Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package fails only as job Expand / Collapse
Author
Message
Posted Friday, September 07, 2012 7:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:13 PM
Points: 697, Visits: 1,721
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.



Post #1355961
Posted Thursday, September 13, 2012 12:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:43 PM
Points: 35, Visits: 89
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)
Post #1358793
Posted Thursday, September 13, 2012 10:34 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:19 AM
Points: 1,101, Visits: 5,271
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.
Post #1359038
Posted Friday, September 14, 2012 9:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:43 PM
Points: 35, Visits: 89
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.
Post #1359394
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse