我不得不多次这样做，不幸的是，在尝试确定您需要什么时，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 ProvidersOracleCLient Data Provider".
连接字符串看起来像这样(我认为 1521 是默认的 Oracle 端口):

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

(DESCRIPTION=(ADDRESS=(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)))