Help with importing data from Oracle into SqlServer 7.0

[Mario2002]

Hi can anyone help me with a question. I am fairly new to SQLServer 7.0 and need to export data from my Oracle 9 database and import it into my SQL Server database. The Oracle database is setup as a datawarehouse in theory and I need to provide a feed and the code to export the required data into SQLServer. I am not sure exactly what DTC or BCP is, but I will be reading up on it, but if anyone has any quick info that I can read that would be great.

Thanks

Mario

 

[JohnDTampaBay]

There is an article in the March SQL Magazine that covers this in detail.

http://www.SqlMag.com

InstantDoc# 37678 --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[MaffewW]

http://www.sqldts.com

has various stuff too