12 September 2012 by Web Bureau
I have experienced the error "Text was truncated or one or more characters had no match in the target code page" a few times when importing from Microsoft Excel to MS SQL using the SSIS Import Wizard and finally have found the solution. See link below for more information.
"the problem is probably that SSIS samples some number of rows at the beginning of your spreadsheet when it creates the Excel source. If on the ShortDescription column it doesn't notice anything too large, it will default to a 255 character text column"