SqlBulkCopy throwing exception

Question

I'm trying to bulk copy data with 100+ columns into a SQL Server database table. The data may contain around 5000 -10,000 records per set. SqlBulkCopy is throwing an error:

The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

NOTE: the data source and my table both have the same column types and lengths. Even though it is throwing the above exception.

Can anyone tell me where I'm going wrong? Many thanks in advance.

Related: https://stackoverflow.com/q/18140012/243373 – TT. Apr 05 '19 at 06:34 — TT., Apr 05 '19 at 06:34

score 0 · Answer 1 · answered Apr 05 '19 at 06:15

0

Better check once the columns mapping explicitly
This error occurs when column length doesn't match

e.g if the input length is varied i.e if input is of type NVARCHAR(MAX) but the target column is of type NVARCHAR(CONSTANT)

answered Apr 05 '19 at 06:15

Lakshmipathi

1
1

Both the column lengths are the same and are of the same type too, that's what I mentioned in as a NOTE! – Prudhvi Bharadwaj M Apr 05 '19 at 06:33

SqlBulkCopy throwing exception

1 Answers1