Post reply

Precedence Constraints

  • April 22, 2009 at 1:36 am

    #202337

    Hi All,

    I have a question about Precedence Constraints in data flow task. My scenario is i have used multicast to connect multiple destination. In that destination i have inserted to some of the tables. Destination2 table having foreign key of destination1. The destination2 will start once the destination1 completes. I dont know how it was worked. Whether i need to put any precedence over there.

    Thanks in advance

    Pras

  • April 22, 2009 at 8:00 am

    #982194

    aprasy (4/22/2009)

    Hi All,

    I have a question about Precedence Constraints in data flow task. My scenario is i have used multicast to connect multiple destination. In that destination i have inserted to some of the tables. Destination2 table having foreign key of destination1. The destination2 will start once the destination1 completes. I dont know how it was worked. Whether i need to put any precedence over there.

    Thanks in advance

    Pras

    Split your loading process in two separate data flows and make the second data flow execute only after the first data flow is done. There is no precedence constraint in a data flow.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • April 28, 2009 at 12:12 am

    #984845

    Thanks for your reply. I dont know how to run the second data flow task while the first data flow task is done. Can u clear this? I am curious to know how to do that.

    Thanks

  • April 28, 2009 at 1:17 am

    #984865

    You will have two dataflows appearing on your Control Flow - simply join (a) to (b) and you can be sure that (b) will execute after (a).

    Not sure that helps you - as you want all of the processing controlled within a single DF task, I think. I can't see an obvious way of controlling precedence immediately after a Multicast, but I'm betting CozyRoc has a solution.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 28, 2009 at 5:46 am

    #984982

    aprasy (4/28/2009)

    Thanks for your reply. I dont know how to run the second data flow task while the first data flow task is done. Can u clear this? I am curious to know how to do that.

    Thanks

    You just connect the data flow tasks with the standard connector.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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