I found the answer to this. Any user who is not sysadmin has to have access to the proxy granted explicitly.

To grant access proxy accounts for non-sysadmins

1.In Object Explorer, expand...

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?...