Cannot convert between unicode and non-unicode string data types

Submit Blog |

Blogs Home |

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

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx

Found interesting? Add this to:

| More | Bookmark It

More Blogs from Jvprabhusanthi

More ...

About Venkatesan Jayakantham

Experience:	9 year(s)
Home page:	http://www.dotnetfunda.com
Member since:	Tuesday, May 01, 2012
Level:	Starter
Status:	[Member]
Biography:

>> Write Response - Respond to this post and get points

More Blogs
	Import Excel data using c# Replace command in SQL Server SQL Server installation error SSAS error Grab Datatables column Name in C# Issue with Restore database in sql server SeriesCollection Convert Varchar to Xml in Sql Server Insert XML data into SQL Server Submit Blog \| More ...