Should I install Oracle 64 bit OLE DB drivers to speed up data flow speed.?

I'm experiencing extremely slow transfers of data from oracle to SQL in my DTS package. I'm using a data flow task and regular OLE DB connections for source and destination.

Linked Servers:

I'm trying to time the amount of time it takes to run the query against the oracle server.

There is only one Oracle driver in the list of drivers for creating a new linked server

"Oracle Provider for OLE DB"

which is weird since I have both the 32 bit and 64 bit ORaclient drivers installed (I'm assuming visual studio can only detect the 32 bit drivers)

If I create an Oracle linked server using this driver, the query seems to work but then produces a weird error.

However creating a linked server with the "Microsoft OLE DB Provider Oracle" ...works but is still extremely slow.

Are there any settings/property (increase buffer/increase packet size) changes I can make to the OLE DB Oracle source/package/workflow task to speed things up?

There are no indexes in the table I am importing into.

I am using a simple sql select statement (select * from table).

Pulls from sql are over 11 times faster than pulls from Oracle and I need to pull around 23 million rows.

Has anyone come across the linked server driver issues?

I'm using a 64 bit server with windows server 2003 64 bit version.

Please advise.

Thanks

[1558 byte] By [rl_atc] at [2008-1-2]