Menu
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?
994
The Oracle Provider for OLE DB allows high performance and reliable access to Oracle databases for ADO- or OLE DB-enabled applications. Current ADO and OLE DB programmers can easily migrate to the Oracle provider because it complies with the OLE DB specification.
Connecting to Oracle in SSIS is a two-step process. First you install the Oracle client software, and then you use the OLE DB provider in SSIS to connect to Oracle. To be sure, the Microsoft Data Access Components (MDAC) that comes with the operating system include an OLE DB provider for Oracle.
You have to download and install the Oracle Data Access Components (ODAC) 32-bit:
Download Link
Helpful Links
192
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
