Import from Oracle to SQL Server 2000

• Madhavi Joshi

  SSC Rookie

  Points: 48

  More actions

  May 24, 2004 at 5:37 pm

  #82690

   Hi,

  I need to import data from a file generated by Oracle as Full Database Export. I tried DTS Import/Export Wizard to import data but got errors. Is there any other way to do this?

  Thanks

  MJ

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  May 24, 2004 at 8:59 pm

  #507572

  I believe you have to install the Oracle client on the SQL Server first.

  ---

  Kindest Regards,

• rs

  SSCrazy

  Points: 2819

  More actions

  May 25, 2004 at 7:55 am

  #507650

  What type of file is that? (means like csv or ...)

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 25, 2004 at 11:09 am

  #507721

  DTS can't read an Oracle export file.  Only the Oracle Import utility can read it.

   

  Greg

  Greg

• Madhavi Joshi

  SSC Rookie

  Points: 48

  More actions

  May 25, 2004 at 11:27 am

  #507726

  Thanks Greg !!

   

   

• Madhavi Joshi

  SSC Rookie

  Points: 48

  More actions

  May 25, 2004 at 11:28 am

  #507727

  Thanks..