Rajesh's Blog

My Photo
Name:
Location: Bangalore, India
Google

Tips to Reduce Abdominal Fat!

Thursday, July 21, 2011

SSIS- Cannot convert between unicode and non-unicode string data types

I was trying to read data from a CSV file and move records to SQL Server 2008 tables using SSIS 2008. I encountered an error "cannot convert between unicode and non-unicode string data types ssis 2008". I could fix this issue by following the same given at http://www.mssqltips.com/tip.asp?tip=1393. Worth reading it if using SSIS.