Posted on 2009-02-24
I keep getting this error anytime i try to excute a job to run an SSIS package, can anyone tell me what im doing wrong?
Executed as userXXX\sqlservice. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:07:16 Error: 2009-02-24 12:07:16.56 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: 2009-02-24 12:07:17.11 Code: 0xC0202009 Source: refresh_style_colour_dims 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 OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied ". End Error Error: 2009-02-24 12:07:17.11 Cod... The package execution fa... The step failed.