Pulling data from a Oracle database to a SQL Server database

Aycex · #1 (**permalink**) 03-28-02, 10:36

I have been tasked with pulling data from a clients Oracle database using a SQL Server Stored procedure. I need to know how to point it in the correct direction . Any ideas on a way to set this up as a stored procedure?

aliviu · #2 (**permalink**) 03-29-02, 03:38

You may register Oracle in SQL Server Enterprise Manager, as a linked server, and then use the syntax for distributed queries, in your stored procedure.

msalvador · #3 (**permalink**) 03-29-02, 07:11

if you have only to transfert data you can use dts tool