bulk insert

[cmsbuffet]

When I execute this code

USE Zipcodes2
GO
BULK INSERT ZipCodes4
FROM 'd:\cmsbuffet\correct_database.csv'
WITH (FIELDTERMINATOR=';', ROWTERMINATOR = '\n')

I get this error, what does it mean?

Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.
Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45235, column 5 (StateAbbreviation).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45236, column 5 (StateAbbreviation).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45237, column 5 (StateAbbreviation).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45238, column 5 (StateAbbreviation).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45239, column 5 (StateAbbreviation).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 45240, column 5 (StateAbbreviation).

 

[cmsbuffet]

Apparently, it was a very interesting situation. The bulk transfer was occurring, but it wasn't adjusted for the EOF. So I got 180,000 records in database before I realized what was going on. Now I recreated the table, it is supposed to have 45234 rows. Unfortunately, it holds now 45237 rows. Is it OK? How do I fix it? Thanks.

 

[cmsbuffet]

Does anyone know how to clean up the code, so that it won't produce any errors, and which would be EOF-compliant?