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.