BCP

• anthonyguzzo

  Newbie

  Points: 1

  More actions

  June 6, 2003 at 11:39 am

  #159231

  I am trying to do the following BCP:

  bcp tempedi.dbo.edidataclient_tblImportPreRawTXT in c:\tabtxt.txt -fc:\bcptabtxt.fmt -ec:\tabtxterr.txt -SDEV -U***

  -P*** -v -k

  BUT I keep getting to following errors:

  #@ Row 1, Column 5: String data, right truncation @#

  #@ Row 2, Column 1: String data, right truncation @#

  etc...

  When I look at column 5 and 1 there should not be any problems:

  What should I be looking for? What causes this error?

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 6, 2003 at 12:38 pm

  #460251

  Look at your table column data types, if you're dealing with varchar or nvarchar

  your table columns might not have enough room to store imported data.

  MW

  
  MW