Bulk Insert Failure

• peddi_praveen

  Mr or Mrs. 500

  Points: 550

  More actions

  November 18, 2003 at 10:20 am

  #83484

  hi guys,

  im encountering following error:

  Server: Msg 4863, Level 16, State 1, Line 1

  Bulk insert data conversion error (truncation) for row 19715, column 34 (ListingDataListPriceCurrencyCode).

  I i did not find any abnormality in that row.

  I deleted that row and ran again encountered error again

  im encountering following error:

  Server: Msg 4863, Level 16, State 1, Line 1

  Bulk insert data conversion error (truncation) for row 19714, column 34 (ListingDataListPriceCurrencyCode).

  i went on deleteing records.... kept on getting same error.

  then i changed my bulk insert stmt , specified firstrow , lastrow param...

  first 1- last 19714-- successful

  first 19715 - last 19715 -- failure, same error

  first 19716 - last end of file -- successful.

  I thought i narrowed down the error n copied that record into new file,

  tried to bulk insert from that file.....

  ...... Successful.

  Im at cross roads.....

  any one encountered this...?

  Please Help

  Praveen Kumar Peddi

  
  Praveen Kumar Peddi

• David Burrows

  SSC Guru

  Points: 65111

  More actions

  November 19, 2003 at 6:42 am

  #482616

  Check the contents of the input file for the record in question (use a hex editor) and check that the row has the correct number of columns and is terminated correctly. When you edit the file and copied the data you may have removed the problem.

  Far away is close at hand in the images of elsewhere.
  Anon.