Bulk Load Data Conversion Error (Truncation)

Bulk load data conversion error (truncation)

It's picking up the commas within the comments field as delimiters, because the delimiters are not consistent. The best solution is to insure that all fields are wrapped with double quotes and set FIELDTERMINATOR to '","'. Alternately, replace the commas with something unlikely to be in the comments (like ~) and set FIELDTERMINATOR = '~'.

Bulk Insert Failed Bulk load data conversion error (truncation)

The problem is likely the row terminator is not working due to the file format.

Try:

ROWTERMINATOR = '0x0a'

EDIT

Actually I just notice you are using forward slash, it should be backslash, so this may work:

ROWTERMINATOR = '\n'

error Bulk load data conversion error (truncation) when inserting data from a text file

Try
bulk insert [dbo].[IB_Emetteur]
from 'C:\Users\Manu\Documents\GL5\Finance\liste_emetteur.txt'
with (fieldterminator = ',', rowterminator = '\n',FIRSTROW = 2)
go

SQL Bulk load data conversion error (truncation) (Restatement_Reason)

Check the data you are trying to bulk insert.
More specific, check row 13651 and column 201.

It propably means that the data in that location is too wide for the column you are trying to insert it into.

---

Related Topics