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