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?

  • 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

    Greg