Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied

• jhbusca

  SSC Veteran

  Points: 270

  More actions

  August 4, 2010 at 11:09 am

  #97491

  Hi,

  I built the SSIS packge to important data from oracle and store to lcoal. When I run the manually,it works fine. However,I tried to run the package on SQL server agent job, it failed give me following message. I tried to create the configuration file and set up protection level to "Do not save sentitive ...' . But still not works. Please help !!

  Message

  Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied". End Error Error: 2010-08-04 09:49:24.10 Code: 0xC020801C Source: Data Flow Task OLE DB Source [71] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ssdprd02.barnesjd" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2010-08-04 09:49:24.10 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "OLE DB Source" (71) failed validation and returned error code 0xC020801C. End Error Error: 2010-08-04 09:49:24.10 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-08-04 09:49:24.10 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:49:22 AM Finished: 9:49:24 AM Elapsed: 1.219 seconds. The package execution failed. The step failed.[/size][/i]