Monday, December 13, 2010

SSIS: Column cannot convert between unicode and non-unicode string data types

If you try to import Excel data into SQL Server you may get this error having to convert the columns from Unicode to non-Unicode.


Use the Data Conversion Task
So to get around this problem we have to also use a Data Conversion task. This will allow us to convert data types so we can get the import completed. Map the non-unicode columns with unicode version of the columns and import the data to SQL server.

No comments:

Post a Comment