To make the job fail I think you would have to make that a fatal error in the SSIS package. It looks like the truncation just gave you a warning? Have you tried setting that field to fail on truncation?