One of our SSIS package jobs failed. The error message showed, the input data was truncated. When openning the package, what I can see are some warnings. The destination table has longer length than that in the source.
In my memory, the truncation should not fail a package. Please give your input.
Many thanks.