使用Sql Server Integration Services连接到Oracle数据库 [英] Connecting to Oracle Database using Sql Server Integration Services

问题描述

我需要使用SSIS将数据从Oracle数据库获取到Sql数据库.

I have a requirement to get the data from Oracle database to Sql Database using the SSIS.

我使用的是SQL Server 2012 Standard Edition 64位，而oracle是11g.

I am using sql Server 2012 Standard Edition 64 bit and oracle is 11g.

我尝试下载将oracle驱动程序(64位Oracle数据访问组件(ODAC))安装在Sql Server中，这将允许我连接到Oracle db，但无法实现同样的目的.

I tried downloading the oracle drivers(64-bit Oracle Data Access Components (ODAC)) to install in Sql server with will allow me to connect to Oracle db but not able to achieve the same.

请帮助我解决问题.

推荐答案

我不得不多次这样做，但不幸的是，Oracle网站在确定所需内容时并不是特别有用.

I have had to do this on many occasions, unfortunately the Oracle website is not particularly helpful when trying to determine what you need.

您需要下载的副本 可以在以下位置找到"ODTwithODAC1120320_32bit.exe":

You need to download a copy of "ODTwithODAC1120320_32bit.exe" which can be found at:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879 .html

64位版本没有用，32位驱动程序可以正常工作.如果要从代理运行程序包，请在开发计算机上和SQL Server框中安装此程序.

The 64-bit version is of no use, the 32 bit drivers will work just fine. Install this on your development machine and on the SQL Server box if you want to run the packages from the agent.

然后可以选择提供程序".Net Providers \ OracleCLient数据提供程序".
连接字符串如下所示(我认为1521是默认的Oracle端口):

You can then choose the provider ".Net Providers\OracleCLient Data Provider".
The connection string will look some like this (I think 1521 is the default Oracle port):

(DESCRIPTION =(地址=(PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = xxxxx)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxxxx)))

这篇关于使用Sql Server Integration Services连接到Oracle数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！