Oracle OLE DB Provider not Listed in SSIS

Question

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?

What is the error that you are getting when you try to use 'Microsoft OLE DB Provider for Oracle'? — VKarthik, Jul 17 '17 at 00:01
The error I get is: The specified provider is not supported. Please choose different provider in connection manager. — MagdielAybar, Jul 17 '17 at 12:24

score 3 · Accepted Answer · answered Jul 14 '17 at 21:42

3

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

answered Jul 14 '17 at 21:42

Hadi

36,233
13
65
124

I installed it and it didn't worked. Anything else I can try? – MagdielAybar Jul 17 '17 at 12:19
@MagdielAybar http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html – Hadi Jul 17 '17 at 12:48

score 2 · Answer 2 · answered Apr 21 '20 at 14:52

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.

answered Apr 21 '20 at 14:52

Vasilii P

349
2
10

Oracle OLE DB Provider not Listed in SSIS

2 Answers2

Linked