bulk load error

Raj 21 Reputation points
2021-01-28T12:12:25.077+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,883 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,201 Reputation points
    2021-01-28T13:11:14.747+00:00

    @Raj

    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.


0 additional answers

Sort by: Most helpful