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

Problem

If you are using Upsert Destination and suddenly you start getting below error. 

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

Possible Cause

That means some of your nvarchar datatype column value is too large to fit in the column data area of the buffer. Let's say in the database table you have a column named it as Address and datatype is Nvarchar(50) so its length is 50 and while your source data address string length 100 in that case while you try to load address data in the table it will throw System.Exception: PipelineException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column..

Possible Solutions

In the Database Table, you need to increase the length based on your actual data string length or 4000 for that column.
And after that refresh the metadata in Upsert Destination and try to load the data.

Contact Us

If you have more question(s) feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/