SSIS package fails only as job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS package fails only as job

SSIS package fails only as job

Rate Topic

Display Mode

Topic Options

Author

Message

krypto69

Posted Friday, September 07, 2012 7:19 AM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 624, Visits: 1,546

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

n79799

Posted Thursday, September 13, 2012 12:39 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:30 PM
Points: 35, Visits: 81

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

Suresh B.

Posted Thursday, September 13, 2012 10:34 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 1,075, Visits: 5,116

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

n79799

Posted Friday, September 14, 2012 9:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:30 PM
Points: 35, Visits: 81

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 »

Permissions