sql server - bulk insert error [closed]

Question

Closed. This question is not about programming or software development. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Closed 4 months ago.

Improve this question

I am using bulk insert and getting below error:

Note: The data in the load file is not beyong the configured column length

Running 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')

Contents of load file:

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

Error:

Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 1, column 6 (validated).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

Is column 6 by chance the last field in the row? It sounds like the field or rowterminator may be incorrect. I've seen this in the past. Since it doesn't find the terminator, it thinks the field/row extends on to the next field or row. Just a guess. — brian
– brian, Commented Dec 4, 2012 at 22:55
You don't appear to have 6 columns... Also, formatting is a little different than you might otherwise expect here on SO, so I tweaked your data so that it lines up... which unfortunately resulted in the delimiter tabs going missing (although personally I prefer non-whitespace characters for this anyways). — Clockwork-Muse
– Clockwork-Muse, Commented Dec 4, 2012 at 23:08

Bruce · Accepted Answer · 2012-12-11 20:05:17Z

8

The number of columns was incorrect. I had recently changed the table schema but forgotten to do a refresh on the table.

answered Dec 11, 2012 at 20:05

Bruce

2,21112 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Partridge Over a year ago

same error for me in the same situation: 8 table columns but 7 fields in my CSV

user4524357 · Accepted Answer · 2015-02-03 13:16:14Z

0

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

answered Feb 3, 2015 at 13:16

user4524357

Collectives™ on Stack Overflow

sql server - bulk insert error [closed]

Running Command:

Contents of load file:

Error:

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

Running Command:

Contents of load file:

Error:

2 Answers 2

1 Comment

Comments

Related