I set up a DTS package which loads data from an external system to SQL
Server. When there were data exception errors ie invalid dates, the step
would fail but the job would complete. I checked off Fail Package on First
Error in Package Properties and Fail Package on Step Error on WorkFlow
Properties for that step. Now when the package runs, the step continues to
fail and there is an informational message at the end of the job saying it
failed. The problem is when I run it as a scheduled job, it ends successfully.

1) Is there a way to insure that as a scheduled job if any step fails, the
job ends
unsuccessfully ?
2) Is there a way to stop processing as soon as a step fails instead of
wait until the
end of the job ?