CODEWITHSUNDEEP
sql-servercsvbulkinsert
Daulat Daga
Daulat Daga

Reputation: 13

Bulk Insert csv file in SQL server

DELETE test1;
BULK INSERT TEST1 FROM 'D:\Monday\Omni\traffic.csv' WITH(FIRSTROW = 2, 
FIELDTERMINATOR = ',', ROWTERMINATOR = '0x0a');
    SELECT *
    FROM test1;

While selecting data type of visit to numeric or int it is showing this error

"Msg 4863, Level 16, State 1, Line 2 Bulk load data conversion error (truncation) for row 2, column 5 (visit)."

But while changing data type to varchar(40), getting visits like "23232,,,,,,,,,,"

in every row of visit column and I also checked the csv file formatting is set to "General" for this column Please help!

Upvotes: 1

Views: 3699

Answers (1)

Sergio Prats
Sergio Prats

Reputation: 1213

I have found another thread that talked about the same error:

Bulk load data conversion error (truncation)

The problem may be that there are text fields with the field separator inside. If your text files are not quoted and there is some comma inside them, that can confuse mess the process and cause this error.

Upvotes: 0

Related Questions