Post reply

DTS - Restart from Failed Step

  • January 21, 2003 at 3:45 pm

    #357687

    Here is my senerio. I have 4 DTS packages each with around 20 steps. I created a DTS Driver Package which simply runs the 4 DTS packages each as their own step.

    What I am having troubles with is when DTS package 2 fails on its own step 10. How can I get it so I can reexecute the process from step 10 of package 2 instead of rerunning everything?

    Thanks for any suggestions, you can also email me at work cshepherd@ltcg.com

  • January 21, 2003 at 5:16 pm

    #446926

    You would need to handle the restart point within the child packages.

    Basically, if the package fails you log what step it failed at. On restarting you check if there was a previous failure. Then, starting from the failed step, traverse back up the precedence tree changing the ExecutionStatus for each step to Completed. Then set the ExecutionStatus for the failed step to Waiting. Probably a fair bit of coding.

    Another way to approach it would be to break up your large packages into smaller ones. So for your 20 step package where you don't want to re-run steps 1-9 when step 12 fails, create one package with steps 1-9 and another with steps 10-20.

    AS an example of this, we have a few DTS packages here that load data into a datamart from text files. Rather than getting two seperate files, quite often the file will contain both dimension and fact data.

    For these files we have a package that executes four child packages. The first package loads the extract file into a staging table. The second package loads the dimension data from the staging table into the dimension table. The third package loads the Fact data from the staging table into the Fact table. The last package processes a couple of summary tables. This way if the staging and dimension load succeed, but the fact load fails, we can just run the fact and summary packages.

    Let me know if I can provide any further help.

    Thanks

    Phill Carter

    Edited by - phillcart on 01/21/2003 5:17:04 PM

    Edited by - phillcart on 01/21/2003 5:18:10 PM

    --------------------
    Colt 45 - the original point and click interface

  • January 22, 2003 at 7:07 am

    #446955

    Thanks, that makes since, I was curious to see if there was a process similar to a job where you simply can specify which step to restart. But code will have to do. Thanks for the advice.

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

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