Oracle OLE DB Provider not Listed in SSIS

sql-server oracle ssis etl odac
MagdielAybar picture MagdielAybar · Jul 14, 2017 · Viewed 14.9k times · Source

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.

enter image description here

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

Answer

Hadi picture Hadi · Jul 14, 2017

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

Download Link

Helpful Links

Related questions

SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for Oracle and I am using this query: SELECT ID FROM Test I get an error message saying: the value cannot …

Read More
How to connect to Oracle db from SSIS/SQL Server Data Tools?

I have Oracle 11g r2 client installed on my 64 bit machine running Windows Server 2008 r2. Have the following installed: SQL Server 64 bit MS Office 64 bit I tried connecting from excel/powerpivot to the oracle db, it works perfectly fine. However, …

Read More
SQL Agent Job - Connection may not be configured correctly or you may not have the right permissions on this connection?

I'm getting this error when running an SSIS package through SQL Agent Failed to acquire connection "ORACLE ADO.NET". Connection may not be configured correctly or you may not have the right permissions on this connection. When I log on …

Read More