SSIS missing Oracle provider for OLEDB driver in connection manager

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  August 29, 2016 at 5:44 pm

  #312936

  We are using oracle as data source for some SSIS packages.

  For package to work we need Oracle provider driver that downloaded from Oracle site.

  So I installed Oracle ODAC 32 client for oracle 12c named ODTwithODAC121010

  Then installed for 64 bits too, file name ODAC121010_X64.

  From oracle universal installer tool on the server, I can see both 32 bits and 64 bits Oracle provider for OLEDB are installed.

  But in SSIS visual studio tool, when I create a connection manager, I cannot see oracle provider on the list.

  What could be wrong?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 30, 2016 at 6:55 am

  #1898294

  I've usually had to manually register the dll. You could try that - Run regsvr32 YourPathTo\oraoledb12.dll

  Sue