sql server dts: DTS - Oracle -- sql server dts

Re: DTS - Oracle

Sue Hoegemeier
3/12/2004 8:42:42 AM

You need to install and configure the Oracle client that
comes with your Oracle CD. It needs to be installed on the
computer that will be executing the package. If you are
going to schedule the package, it will need to be installed
on the SQL Server box.
You can find some related information in the following
article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106

-Sue

On Fri, 12 Mar 2004 07:31:08 -0800, "G"
[quoted text, click to view]

DTS - Oracle

Cheryl
3/24/2004 11:41:12 AM

[quoted text, click to view]
I have the same problem. I only want to retrieve data from
an Oracle table, but apparently we have to purchase the
Oracle client (which I don't want or need) to get the
driver to query the Oracle database.

Re: DTS - Oracle

Sue Hoegemeier
3/24/2004 1:47:41 PM

If you don't want to use the Oracle client then you can't
directly connect to the Oracle instance. If you are a
licensed client for the Oracle server, you can use the
Oracle CD to install the client - it's not a separate
purchase.
If you don't want to go that route, another option would be
on the Oracle side, have the data from the table spooled out
to a text file. Move that file to some place you can access
it from SQL Server and work with that text file instead.

-Sue

On Wed, 24 Mar 2004 11:41:12 -0800, "Cheryl"
[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.