SSIS Excel Data Source: Text was truncated or one or more characters had no match in the target code page.
Using SQL Server 2005 SSIS to import an Excel Spreadsheet into a SQL Server database. Kept getting this error. [Excel Source ] Error: There was an error with output column “Comments” (5691) on output “Excel Source Output” (5596). The column status returned was: “Text was truncated or one or more characters had no match in the target code page.”.
For the solution to this problem, please see this link