DTS Package Scheduled Job Result Issue

I am using SQL Server 2000. I created Package1, Package2, and Package3. If I ran from scheduled job Package2 and it failed, the result in Job History is Failed. If I ran from scheduled job Package1 that runs Package2 and then Package3 and Package2 failed, the result in Job History on Package1 is Successful. Why? How can I have the result Failed so I can get the failure notification.

Thanks,

DanYeung

look at DTS Package Properties at Logging tab; there is a check box "Fail package on first error", see if it is on or off.|||

I couldn't find the Logging tab on the DTS Package itself (atually there is no properties when I right clicked) and the schedule job under SQL Server Agent - Jobs. The tabs on the schedule job are General, Steps, Schedules, and Notifications. I am using SQL 2000. Can you please advise? Thanks

DanYeung

|||

in "locale packages" of DTS in Enterprise open yor package, right click on window surface and then "Package Properties"

|||

It works. I have to check it in all 3 pacakges. Thank you.

DanYeung