September 10, 2009 at 4:22 am
Hi ,
I am developing a package which pulls high volumes of data from an Oracle server into a SQL server.
I would like to know which provider would be better (i.e faster) on the Oracle server
Microsoft OLE DB Provider for Oracle or Oracle Provider for OLE DB
September 10, 2009 at 5:18 am
The Oracle provider should be faster... but not sure... 🙁
September 10, 2009 at 6:13 am
i have tested the package with Oracle Provider.
It runs for about 20 minutes and fails at the Source. no data transfer occurs
When i ran it with Microsoft provider, it runs for about 40 minutes before the source turns yellow and the actual data transfer occurs. it runs for about 20 more minutes after which the data transfer is completed.
Since i am not able to test it with Oracle provider, i am not able to test the speed difference for both.
though, i might be able to use the Oracle provider, i still want to know which is faster.
September 10, 2009 at 7:52 am
What is the error you are getting... when ur using Oracle provider...
See that u use the provider which is supported to your version of Oracle source... in SSIS 2005 Oracle 8i is supported I suppose, and for the new you have to download the Oracle provider...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply