Re: Data export from oracle 10G to SqlServer 2000

From: Brian Peasland <>
Date: Mon, 7 Aug 2006 13:36:48 GMT
Message-ID: <> wrote:
> I need to transfer data on daily basis from an oracle 10g database
> running on Linux to the sql Server 2000 database.For that I need first
> to get my query output from oracle into flat file and then bulkinsert
> that file into sqlserver 2000.
> I just read about Oracle Data Pump which could be used for Bulk Export
> .I need to know how could I use data pump to get data out from oracle.

[Quoted] I'd use DTS for this operation. Write a DTS package to query the Oracle database through ODBC and pull the data into SQL Server....



Brian Peasland

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Mon Aug 07 2006 - 15:36:48 CEST

Original text of this message