Hi -- Here is the entire log for the Job Agent. There are two steps involved: Step 1 drops the existing RAW.PERRANK table so that it can be replaced. Step 2 calls the SSIS package to copy the table PERRANK from the Oracle database into a new
table in SQLServer called RAW.PERRANK. I know the error message refers to "Oracle client and networking components were not found" but the package runs fine when I do it in Integration Services and manually enter Password #2.
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 Attempted
06/15/2011 08:58:56,Reload PERRANK,Error,0,EASTERN-CD3494B,Reload PERRANK,(Job outcome),,The job failed. The Job was invoked by User EASTERN-CD3494B\wjones20. The last step to run was step 2 (Copy PERRANK from BERP). The job was requested
to start at step 1 (Delete old PERRANK).,00:00:02,0,0,,,,0
06/15/2011 08:58:56,Reload PERRANK,Error,2,EASTERN-CD3494B,Reload PERRANK,Copy PERRANK from BERP,,Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft
Corporation 2010. All rights reserved. Started: 8:58:57 AM Error: 2011-06-15 08:58:58.39 Code: 0xC0202009 Source: Copy PERRANK to new table RAW PERRANK Connection manager "SourceConnectionOLEDB"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.".
End Error Error: 2011-06-15 08:58:58.42 Code: 0xC020801C Source: Data Flow Task 1 Source - PERRANK [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection
method call to the connection manager "SourceConnectionOLEDB" 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: 2011-06-15
08:58:58.43 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - PERRANK" (1) failed validation and returned error code 0xC020801C. End Error Error: 2011-06-15 08:58:58.45
Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-06-15 08:58:58.45 Code: 0xC0024107 Source:
Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:58:57 AM Finished: 8:58:58 AM Elapsed: 1.328
seconds. The package execution failed. The step failed.,00:00:02,0,0,,,,0
06/15/2011 08:58:56,Reload PERRANK,Success,1,EASTERN-CD3494B,Reload PERRANK,Delete old PERRANK,,Executed as user: NT AUTHORITY\NETWORK SERVICE. The step succeeded.,00:00:00,0,0,,,,0