SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS package fails only as job


SSIS package fails only as job

Author
Message
krypto69
krypto69
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1232 Visits: 2445
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 "DTSTongueroperty" 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.



n79799
n79799
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 122
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)
Suresh B.
Suresh B.
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1970 Visits: 5326
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.
n79799
n79799
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 122
The below is yopur error :

Failed to decrypt protected XML node "DTSTongueroperty" 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search