Oracle OLE DB Provider not Listed in SSIS

sql-server oracle ssis etl odac

17,328

Solution 1

You have to download and install the Oracle Data Access Components (ODAC) 32-bit:

Download Link

32-bit Oracle Data Access Components (ODAC) and NuGet Downloads

Helpful Links

Solution 2

Only this install worked for me (for Visual Studio 2017): https://www.oracle.com/database/technologies/dotnet-utilsoft-downloads.html

Other ways to install OLEDB provider from multiple forums didn't work.

17,328

Author by

MagdielAybar

EN I've worked with several technologies along my career as developer. To mention a few Java, C#, Oracle, SQLServer, MySql, PHP, JavaScript, .Net, etc. I like to learn new things and help others to learn anything I can share with them. ESP He trabajado con varias tecnologías a lo largo de mi carrera como developer. Entre estas Java, C#, Oracle, SQLServer, MySql, PHP, JavaScript, .Net entre otras. Me gusta aprender cosas nuevas y ayudar a otros a aprender de lo que les pueda enseñar.

Updated on June 12, 2022

Comments

MagdielAybar almost 2 years

I'm having an issue with SSIS and VS2015 CM.

I have a package that needs to connect with Oracle to get some data. I installed the ODAC for Win64 and the Oracle client but I can't see the Oracle provider for OLE DB listed in the providers list.

Although I can see the Microsoft OLE DB provider for Oracle it doesn't work when I try to use that provider either.

What should I do to get the Oracle OLE DB provider listed?