Unicode and Non-Unicode string data types

Cannot convert between unicode and non-unicode string data types

While trying to push the data from Flat file to SQL Server I got the error,

" Cannot convert between unicode and non-unicode string data types "  - ->

Solution 1 :- The issue is due to mismatch of the source column and the destination column. We can use derived column/DataConversion tools to map to appropriate data type.

Solution 2 :- For time being, I've changed the destination table columns from unicode(nvarchar) to varchar. Since, it doesn't have any impact on my system.

I am happy with solution 2.

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech