Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: DTS'ing Oracle data into SQL Server

    I need to import some data from Oracle into Sql Server.

    I've installed the Oracle's OleDB provider (OraOLEDB_92020.exe).

    Do I need to install anything else on the SQL Server so that I can import the data?

    Cheers

    Nick

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: DTS'ing Oracle data into SQL Server

    Originally posted by riggers
    I need to import some data from Oracle into Sql Server.

    I've installed the Oracle's OleDB provider (OraOLEDB_92020.exe).

    Do I need to install anything else on the SQL Server so that I can import the data?

    Cheers

    Nick
    I don't think so

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    linked server

  4. #4
    Join Date
    Sep 2003
    Posts
    2
    I've tried just installing the OleDb provider but it appears from furthering reading on the web that I need to install the oracle client tools aswell as the OleDb provider.

    I've been told that we are running Oracle 10.7 and I can not appear to find the client tools for this on Oracle's website.

    Does anyone know where the client tools for this version of Oracle are?

    Cheers

    Nick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •