Use the Process Model window to specify that a step be started upon successful completion of another step.
For example, you can specify that the target table of one step is the source table for a second step. You can use the Process Model window to specify that the second step is to start only if the first step runs successfully, thus maintaining data integrity.
To start a step when another step runs successfully:
Click 
(the Data Link icon).
Click 
(the On Success icon).
Click the step that is to run first.
Hold down the mouse button and drag the mouse to the step that is to run after the first step.
Release the mouse button.
A green arrow that represents the task flow is displayed on the canvas between the two icons.
Click Process --> Save to save the changes that you have made to the process.
Related information