Forum Discussion
Can I BULK INSERT a column > 8000 chars?
Howdy! I've scoured the internet on this but am coming up blank - so apologies if this has already been asked.. I've been asked to import a .csv where one of the columns exceeds 8,000 chars....
hi olafhelper!
Here's the error I hit..
BULK INSERT <table_name>
FROM 'file.csv'
WITH
(
FORMAT='CSV',
FIRSTROW=2,
FIELDQUOTE = '"'
)->
Msg 4863, Level 16, State 1, Server <server_name>, Line 3
Bulk load data conversion error (truncation) for row 2, column 10 (<column_name>)...but if I were to manually edit the .csv and remove a few chars from the .csv to bring the column data < 8,000 chars then it works fine.
The column type is a VARCHAR(MAX) but I'm guessing that BULK INSERT is using a native VARCHAR datatype..
I.
- I figured it out! I was BULK INSERTING into a VIEW (because I had some DEFAULT values that weren't included in the .csv). Switching to BULK INSERT into a table worked.
