SSIS中未列出Oracle OLE DB提供程序 [英] Oracle OLE DB Provider not Listed in SSIS
问题描述
我在使用SSIS和VS2015 CM时遇到问题.
I'm having an issue with SSIS and VS2015 CM.
我有一个需要与Oracle连接以获得一些数据的软件包.我安装了ODAC for Win64和Oracle客户端,但是在提供程序列表中看不到OLE DB的Oracle提供程序.
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.
尽管我可以看到Oracle的Microsoft OLE DB提供程序,但是当我尝试使用该提供程序时,它也不起作用.
Although I can see the Microsoft OLE DB provider for Oracle it doesn't work when I try to use that provider either.
我应该怎么做才能列出Oracle OLE DB提供程序?
What should I do to get the Oracle OLE DB provider listed?
推荐答案
您必须下载并安装32位Oracle Data Access Components(ODAC):
You have to download and install the Oracle Data Access Components (ODAC) 32-bit:
下载链接
有用的链接
- Oracle Provider for OLE DB Releasse notes
- Oracle Provider for OLE DB
这篇关于SSIS中未列出Oracle OLE DB提供程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!