Home Forums SQL Server 7,2000 Administration How to import Oracle dmp file into SQL Server 2000 or 2005? RE: How to import Oracle dmp file into SQL Server 2000 or 2005?
Greg Charles
SSC-Forever
Points: 45403
More actions
July 18, 2007 at 2:22 pm
#720539
Sorry, it can't be done. Oracle dmp files can only be read by the Oracle import utility. You'll have to import the contents of the file into an Oracle database then import the data into SQL Server using DTS or SSIS.
Greg