DTS - ERROR Handling

[CW1]

Hello

I have following problem.
I create an DTS. In the DTS I defined an OLE-DB -Connection and an SQL-Task.

The syntax from the SQL-Task is very simple e.g.
1. update XX set field = '' .....
2. execute STORED_PROCEDURE
3. update XY set field = '' .....
When I execute the DTS and the STORED_PROCEDURE RETURN an ERROR the DTS-SQL Task write SQL-Task executed successfully.

When the syntax from the SQL-Task is only the 'execute STORED_PROCEDURE' --> and the Procedure return an Error the DTS-SQL-Task write
SQL-Task failed...

What can I do that the SQL-Task Return an ERROR when some step create an Error-Message.

Can anybody help me?
Thank you