Re: Easiest way to transfer data from Oracle to SQL Server using a file.

As I stated in my original post i MUST go via a file of some sort so that really isn't an option for me. Any suggestions there ?

//Linus

"James Williams" <willjamu_at_mindspring.com> wrote in message news:3ef258dd.7049918_at_nntp.mindspring.com...
> On Tue, 17 Jun 2003 11:24:05 +0200, "Linus Nikander"
> <linus_at_nikander.net> wrote:
>
> Easier to me than DTS is to create a Linked Server in Enterprise
> Manager using and Oracle or MS driver for Oracle.
>
>
> Then you can say
>
> insert into xxx
> select * from xxxx1..scott.emp.
>
>
> Wher xxxx1 is the linked server you created via EM or the SP_A* (SQL
> has these crazy stored proc's!) using the appropriate driver.
>
>
>
>
>
Received on Tue Jun 24 2003 - 23:34:27 CEST