We are experiencing timeouts when transferring data from an Oracle database using SSIS packages into a SQL database.
What could be the case of the following message?
Message
Executed as user: HPC\SQLSrvDB03T. Microsoft (R) SQL Server Execute Package Utility Version 13.0.5216.0 for 32-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 16:24:44 Error: 2018-11-19 16:25:02.73 Code: 0xC0209302 Source: BulkUpload_1 Connection manager "172.16.40.155/nreg_pri.lisa" Description: The requested OLE DB provider OraOLEDB.Oracle.1 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2018-11-19 16:25:02.78 Code: 0xC020801C Source: Load APPLICATIONDETAILS OLE DB Source [345] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "172.16.40.155/nreg_pri.lisa" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2018-11-19 16:25:02.82 Code: 0xC0047017 Source: Load APPLICATIONDETAILS SSIS.Pipeline Description: OLE DB Source failed validation and returned error code 0xC020801C. End Error Error: 2018-11-19 16:25:02.82 Code: 0xC004700C Source: Load APPLICATIONDETAILS SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2018-11-19 16:25:02.85 Code: 0xC0024107 Source: Load APPLICATIONDETAILS Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 16:24:44 Finished: 16:25:03 Elapsed: 18.453 seconds. The package execution failed. The step failed.