Found the problem...you are right, it was caused by the update statement that is trying to update a column (varchar8) with data from SYSTEM_USER.  The reason, it runs fine in Query...

The job failed with the following message at the end of the log file:

Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE

22001]

Msg 3621, Sev 16: The statement...

I found the solution...all I needed is to remove the exec privilege on sp_add_dtspackage stored procedure from the public.

Thanks,

--Allan

Thank you all for the useful information!

Now, I can inform the developer that we can't trap or log fatal error, especially the one in between 11 and 18.

Thanks again!

--Allan