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
NickOriginally 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|||linked server|||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
Showing posts with label dtsing. Show all posts
Showing posts with label dtsing. Show all posts
Subscribe to:
Posts (Atom)