Clever Geek Handbook

Oracle OLE DB Provider is not included in SSIS

I have a problem with SSIS and VS2015 CM.

I have a package that needs to communicate with Oracle to get some data. I have installed ODAC for Win64 and Oracle client, but I do not see the Oracle provider for OLE DB listed in the provider list.

While I can see Microsoft's OLE DB Provider for Oracle, it doesn't work when I try to use that provider.

enter image description here

What do I need to do to get a list of Oracle OLE DB providers?

+3


source to share


1 answer


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

Download link



useful links

+1


source






More articles:


All Articles