Navigation

RSS: Matt Pavey RSS Feed

Tuesday, November 11, 2008 @ 8:24 pm,SSIS,Matt Pavey

"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.

The opinions expressed on this website are my personal opinions
and do not represent my employer's or my clients' views in any way.