Post reply

How two different task can goto one task in SSIS

  • September 29, 2010 at 1:13 am

    #228851

    Hi,

    please see the figure to get idea of the scenario.

    Now when my Package will run after executing the s! task, either A or B path will be followed. So If A is followed then Task S2 and F2 is executed. But if path B is followed, task F1 and F3 is executed. But also after completing task F3, the flow should go to task S2 via path E. But this doesn't happen and as the task F3 is completed, the package ends with success.

    I need help on this on how to move to path E and execute task S2 and F2 after task F3 completion.

    Thanks.

  • September 29, 2010 at 4:50 am

    #1228890

    The image is not visible...could you add it as an attachment file

    Anyways it seems to me as a case of precedence constraints

    Raunak J

  • September 29, 2010 at 5:28 am

    #1228900

    Example image uploaded.

  • September 29, 2010 at 8:06 am

    #1229044

    I think that all you need to do is set the A and E to use "Logical OR".


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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