Post reply

Using Execute Package Tasks

  • November 26, 2002 at 10:16 am

    #159069

    I am using Execute Package Tasks to call another DTS. The issue I am having is if a DTS fails that is called from the Execute Package Task I would expect the Execute Package Task to fail why doesn't it??

    Steve Johnson


    Steve Johnson

  • November 26, 2002 at 4:02 pm

    #442470

    One reason is that the next step in the primary DTS package must be dependent 'on success' of the previous step (displays as green arrow, can be set from the 'Workflow' tab).



    Everett Wilson
    ewilson10@yahoo.com

  • November 26, 2002 at 4:04 pm

    #442471

    It is setup to use On Success of the Task

    Steve Johnson


    Steve Johnson

  • November 26, 2002 at 5:37 pm

    #442491

    Check out "DTS Package Properties (Logging Tab)" in BOL, specifically the 'Fail package on first error' bit.

    Thanks

    Phill Carter

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

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

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