Job reports error, but completes successfully.

[Guiderman]

I've scheduled a DTS job to run everday and 99% of the time it runs without incident. Earlier this week it failed. I corrected the problem, but my concern is that because on of the tasks failed why does the job report successful completion?

The DTS Package that I'm running contains two DTS packages and the second package is supposed to run when the first succeeds.

Here is the message from the job history:
"Executed as user: HERSHEY\sqlcan. ...art:
DTSStep_DTSExecutePackageTask_1
DTSRun OnError: DTSStep_DTSExecutePackageTask_1,
Error = -2147213304 (80042008)
Error string: DTSStep_DTSDataPumpTask_8: Column name 'Type' was not found.
Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp
Help context: 0 Error Detail Records:
Error: -2147213304 (80042008); Provider Error: 0 (0)
Error string: Column name 'Type' was not found.
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts80.hlp Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error = 0 (0)
Error string: (1:TSP - Load Actuals from TSP Actuals Sales and Spends)
SubStep 'DTSStep_DTSDataPumpTask_8' failed with the following error: Column name 'Type' was not found.
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help fi... Process Exit Code 0. The step succeeded.