BCP error

• Keith Edwards

  Default port

  Points: 1446

  More actions

  January 16, 2003 at 9:32 am

  #357685

  My scenario is we import data from a text file and they recently added four new columns to bring the total to 159. I added two varchar(3)and two Float columns to my import table just like the existing columns. Now when I run the BCP program it bombs out with a String Data right truncation error. The file imports fine to my old table if those new fields are ignored. Has anybody run across something similar.

  This is probably something simple, but I figured I would post this in case anyone has run across something like this while I try to solve it. Thanks

  Keith

• jfb

  SSCrazy

  Points: 2469

  More actions

  January 16, 2003 at 10:32 am

  #446533

  That error occurs when you have a char or varchar field with specific length and you try to put longer string into it.

  Johnny...