I am importing a file that has a number of columns including one that has over 800 charachters.
When I use the default settings of nvarchar(255), the import fails - text has been truncated. Fair enough.
I set it the field to nvarchar(4000) and I still get the error - even though I do not have a field that wide.
To top it all - even if I set the mappings to <ignore>, it still complains!!!
Ideally, I would like to get the data in so please answer that for me first.
For future reference, I would like to know how to get round failures on columns I am telling it to ignore..