DTS Step Failure Help

  • I have a DTS package. If any of the last 8 steps fail I need a final step to run that reinstates replication.

    How can I trigger this to run without 8 individual "On Failure" steps? If I do 1 step and link all 8 to it "On Failure" it will only trigger if they all fail I believe?

    Thanks

  • Hi,

    You can use "On Completion", which goes to the next task irrespective of the status (success/failure ) of the preveious task.

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • No I can't use completion as some of these steps rely on the others being successful to continue. I just need If Successful --- Go ahead. If failed ---- head to this final step.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply