SSIS:load data into Oracle性能对比

SSIS2008用Oracle Provider for OLE DB往oracle数据库中写入数据时，速度很慢。

 

 

Donald himself states "I do not expect that Microsoft will write an Oracle fast loader - ....
 But on the other hand I do fully expect that there will be excellent Oracle loading capabilities
 from third parties, who may well live long and prosper in that market."

以上来自：http://consultingblogs.emc.com/jamiethomson/archive/2006/04/07/SSIS_3A00_-Persistent-Oracle-Connector.aspx

 

同时这个blog介绍了个第三方驱动：Persistent's loader

2百万条记录，Using Persistent's loader the same dataset took a little over 2 minutes.

不过遗憾的是，文中给出的两个连接均打不开了。

（Jamie的另一个post也介绍了Persistent Loader：http://consultingblogs.emc.com/jamiethomson/archive/2005/11/15/SSIS_3A00_-Loading-to-Oracle.aspx）

 

然后，找到另外一篇09年的post

Using SSIS to get data out of Oracle: A big surprise!

（http://blogs.msdn.com/b/sqlperf/archive/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise.aspx）

里面提到：Since late last year, Microsoft has made the Attunity connectors to Oracle databases available to Enterprise Edition customers.

安装好Attunity1.1后，简单测试了下：

 

 

 

使用Oracle Provider for OLEDB，默认设置时：

大概1min 4万行记录，

 

使用Attunity，但没有使用Fast Load选项，大概1秒2万条。