richardstk.com
Excel Source Output. The column status returned was: “Text was truncated or one or more characters had no match in the target code page.”
I came across this error when I was attempting to import data from an Excel spreadsheet into a SQL database using SQL Server Integration Services (SSIS) 2005. The error occurs because by default t…