Sql server - bulk insert error

Question

I use bulk insertion and get below the error:

Note. The data in the load file does not depend on the length of the specified column

Run command:

bulk insert load_data from 'C: \ temp \ dataload \ load_file.txt' with (firstrow = 1, fieldterminator = '0x09', rowterminator = '\ n', MAXERRORS = 0, ERRORFILE = 'C: \ temp \ dataload \ load_file ')

The contents of the download file:

user_name file_path asset_owner city import_date admin C:\ admin toronto 04/12/2012 

Mistake:

Msg 4863, Level 16, State 1, Line 1
Bulk upload data conversion error (truncation) for row 1, column 6 (verified).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not provide any error information. Msg 7330 Level 16 State 2 Line 1
Cannot retrieve row from OLE DB provider "BULK" for linked server "(null)".

Answer 1

The number of columns was incorrect. I recently changed the table layout, but forgot to update the table.

Answer 2

I solved the same problem by changing the data type in the schema. I had a date type changed to nvarchar ... It worked