Menu

Want to work with us? We're on the lookout for a talented Digital Project Manager.

We're hiring

Importing from Excel into MS SQL error - "Text was truncated or one or more characters had no match in the target code page"

Web Bureau


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"

http://stackoverflow.com/a/8629065

Grow your businessStart a project with us today.