DTS fails transferring from Text File to Table

• ameighoo

  Newbie

  Points: 3

  More actions

  March 25, 2008 at 1:03 pm

  #121178

  Hi All,

  I have a DTS that deletes all the data from a table, then populates the same table with data from a tab delimited text file.

  The error that occurred was a mis-match in the column names in the text file and the table.

  I edited the table column to reflect the correct column name in the text file.

  However, the same error occurs when I try to manually execute the DTS.

  Can someone help me with this?

  Regards,

  Ariane

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 31, 2008 at 3:50 pm

  #796195

  What kind of mis-match? Make sure data types are also matched.