Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OraOLEDB

Eugen-OracleNov 27 2018 — edited Dec 13 2018

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.

Comments
Post Details
Added on Nov 27 2018
2 comments
3,240 views