"If you have used SSIS to import Excel data into SQL Server you may have run into the issue of having to convert data from Unicode to non-Unicode."
This article discusses some different options for handling Unicode to non-Unicode warning messages that are fairly common if you deal with importing data from one source to another, for example from Excel to SQL.
In my case today I ended up just having to add a Data Conversion transformation between my Excel Source and SQL Server Destination to convert my data-types accordingly.
0 comments: