Oracle Provider for OLE DB RRS feed

  • Question

  • User761313748 posted

    Hi All,

    I am working on a SSIS task in which i need to get data from Oracle database which is on remote server.

    But when created the SSIS package and tried to create the connection from the connection manager using OLE DB connection, I am not able to find the provder 'Oracle Provider for OLE DB' . I have oracle client, toad installed on my machine.Using toad, I am able to connect to the Oracle database.

    Please suggest, for time being I am using 'Microsoft OLE DB provider for Oracle' to make the SSIS working.

    Thursday, January 17, 2013 7:06 AM


  • User761313748 posted

    This has been resolved. I installed the provider on local.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 18, 2013 8:33 AM