Forum Stats

  • 3,770,583 Users
  • 2,253,137 Discussions
  • 7,875,499 Comments

Discussions

OraOLEDB

Eugen-Oracle
Eugen-Oracle Member Posts: 164 Employee
edited Dec 13, 2018 8:09AM in Oracle Provider for OLE DB

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.

Answers

  • User_J1GBE
    User_J1GBE Member Posts: 84 Blue Ribbon
    edited Dec 12, 2018 6:59PM

    > Microsoft (R) SQL Server Execute Package Utility  Version 13.0.5216.0

    > for 32-bit

    > 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.

    > What could be the case of the following message?

    OraOLEDB for 32bit seems to be not registered and the package was run in 32-bit mode.

  • EdStevens
    EdStevens Member Posts: 28,536 Gold Crown
    edited Dec 13, 2018 8:09AM
    Eugen-Oracle wrote:We are experiencing timeouts when transferring data from an Oracle database using SSIS packages into a SQL database.<snip>

    As an aside, you might want to reconsider use of SSIS for this task.

    A few years ago we had a new guy on our team that saw everything through Microsoft goggles.  He used SSIS to move data between Oracle and MSSQL.  Came to me complaining that it was taking over 4 hours to move slightly less than 1 million rows.  After tracing his session I was able to see that SSIS was fetching one row, sending it across the net, inserting it, fetching the next row, etc, etc.  Took me about 10 minutes to write a PL/SQL procedure that did a simple 'insert into ... values (select .. from). And that procedure loaded his 1 million rows in about 4 minutes.