Error executing SSIS , by JOBs.

Question

Post reply

Error executing SSIS , by JOBs.

Jose Ianuck

Right there with Babe

Points: 776
More actions
September 3, 2007 at 10:42 am

#125452

Hi,
When I executed the packages MEDLINK_LOAD01_AUTORIZ_TESTE by Integration Services, Stored Packages MSDB, no problem. But when I execute by JOBs (Job Activity Monitor), I´m receiving the error below , please someone can I help me?
Thanks.
Ian.
Executed as user: CAB-SAUDEAPL\SYSTEM. ....00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:36:11 Error: 2007-09-03 11:36:11.82 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" 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: 2007-09-03 11:36:11.84 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" 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: 2007-09-03 11:36:24.28 Code: 0xC0202009 Source: MEDLINK_LOAD01_AUTORIZ_TESTE Connectio... Process Exit Code 1. The step failed.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Krishna Mohan Kasi Mr or Mrs. 500 Points: 593 More actions · Answer 1

Please check what is the protection level that you have stored.

Jose Ianuck Right there with Babe Points: 776 More actions · Answer 2

Hi, Krishna

I did the migration from DTS Sql Server 2000 to SSIS Sql Server 2005, the protection level is put when you created the file .DTSX, what is the protection level I must to put; I need to execute in another server by JOB Scheduler.Please, is possible you to explaim me with more detail.

Thanks.

Ian.