|
johndawg
Starting Member
2 Posts |
 Posted - 2008-03-28 : 15:43:04
|
| I have a schedule job that errors out on the first step when I attempt to run it. There are 3 packages that I created and I can run them all manually just fine.I get this error when I try to run the job:-----------------------------------------------Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted03/28/2008 13:49:22,ST Customer Data,Error,0,Server01,ST Customer Data,(Job outcome),,The job failed. The Job was invoked by User sa. The last step to run was step 1 (config 1). The job was requested to start at step 1 (config 1).,00:00:01,0,0,,,,003/28/2008 13:49:22,ST Customer Data,Error,1,Server01,ST Customer Data,config 1,,Executed as user: Server01\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:49:23 PM Error: 2008-03-28 13:49:23.23 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" 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: 2008-03-28 13:49:23.57 Code: 0xC0202009 Source: Config 1 Customer Data Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80... The package execution fa... The step failed.,00:00:01,0,0,,,,0-----------------------------------------------Any ideas? Thanks,John |
|
Cannot execute job with multiple packages