Post reply

Precedence inside a Data Flow task

  • August 20, 2009 at 7:08 am

    #135593

    Hi,

    I have an SSIS package that loads data from MS Access to SQL(2005)

    Only 1 Data Flow task is there.

    Inside that Data Flow task, there are many tasks(OLEDB src->OLEDB dest),

    Is there any way to define precedence between these tasks?

    (Reason: Table with foreign key constraint should load after its dependent table)

    Thanks,

    KB

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

  • August 20, 2009 at 7:30 am

    #1042093

    You can add multiple Data Flows to the Control Flow and set precedence constraints between each Data Flow.

  • August 20, 2009 at 7:43 am

    #1042103

    Erik Kutzler (8/20/2009)

    You can add multiple Data Flows to the Control Flow and set precedence constraints between each Data Flow.

    Instead of adding that many data flow tasks,

    is there any way to add precedence inside a single Data Flow task?

    Thanks,

    KB

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

  • August 20, 2009 at 8:00 am

    #1042125

    No you can't.

    You only need to break out the flows that are dependent, so unless you have some huge chain of table relationships, you will probably end up with 3-5 data flows. you put the ones in the first dataflow that don't have any dependencies and those that are at the base of the chain. In the second dataflow you put the ones that are next up on the chain. And so on till you have satisfied the dependencies. You DON'T need a dataflow for each.

    CEWII

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

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