Why am I getting an error about truncation when running an SSIS job?
If I remember correctly SSIS samples the first 1000 rows of a data set to determine the output datatype. If then row 1001+ exceeds the datatype that SSIS chose, you'll get a truncation error. You will need to update offending column to have a longer data type. Look in the advanced menu in your connection.