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.