I have the same problem. Copying data from a Unidata ERP system to SQL Server.

The DTS executes fine in Enterprise Manager but fails to run as a job.

I get the following...