sql server dts: Copy oracle tables into SQL Server -- sql server dts

Copy oracle tables into SQL Server

Fred
3/19/2004 1:26:05 AM

sql server dts:

Hi

I want to copy some tables from an oracle database into a sql server database. I'm a total rookie on Oracle but as far as iI know I usually log in with a "service name", a user and a pw

Now, when I use a DTS package with a Oracle OLE DB provider as my connection, the connection options are "server name", user and pw. Thoose I have, but where do I tell the service name

Many thanks

Re: Copy oracle tables into SQL Server

Sue Hoegemeier
3/22/2004 10:18:26 AM

In the tnsnames.ora file on the client.
You need to install the Oracle client and you can use the
Oracle Net Configuration utility to configure the client and
tnsnames file entries.

-Sue

On Fri, 19 Mar 2004 01:26:05 -0800, "Fred"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.