question

Raj-6888 avatar image
0 Votes"
Raj-6888 asked Raj-6888 commented

bulk load error

I am getting this error

Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 2 (Event_date).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 2 (Event_date).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 2 (Event_date).

sql-server-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered Raj-6888 commented

@Raj-6888

This line has too many quotes:

 1892,”2003-10-11”,”H441.”,”No “Cannabinosis”, other”

You would need to fix it first.

*.csv files always have host of problems where column delimiters, column separators, invisible characters like null terminators \0, special characters based on encoding, and line breaks are in the middle of the actual data.

The most reliable format for data feeds is XML.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

When I query the data, I get result garbage data.

0 Votes 0 ·

solved, thanks.

0 Votes 0 ·

@Raj-6888,

If the proposed solution is working for you, please click "Accept Answer" and up-vote it.
This could be beneficial to other community members who encountered the same issue.

0 Votes 0 ·