How to convert between uni-code and non-unicode string data types
Posted on 2011-03-23
I am trying to upload from excel spreadsheet two columns in text format, to a table in sql 2008 data type varchar
column names from excel to sql table are the same
Trying to upload SSIS Package Excel Source 2010 to OLE DB destination
Error messages on two columns
Error at Data Flow Task [OLE DB Desintation [151]: Column "Code" cannot convert between unicode and non-unicode string data types.
Error at Data Flow Task [OLE DB Destination ]: Columns "Description" cannot convert between unicode and non uni-code string data types.
I have tried different string types but nothing is working. what should I format the spreadsheet two, numbers, text or general