Error Description:External Table is not in the expected format

• Aravind Pg

  SSC Rookie

  Points: 33

  More actions

  December 13, 2005 at 10:41 pm

  #166451

  Hi,

  I am getting this error "Error Description:External Table is not in the expected format" when transfering table data from .dbf format to sql server 2000 using DTS in sql server 2000.Please help to sort this out...

  Regards,

  PG

   

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  December 14, 2005 at 3:44 pm

  #609601

  It sounds like this may be a datatype issue.  Make sure all of your datatypes in your SQL Server table match the data type and length of the incomming data. 

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden