Post reply

how to run multiple dataflow tasks in the same package that use same variables

  • May 31, 2016 at 1:55 pm

    #308146

    hi,

    Is there a way that I can tell ssis to run first DFT and then second DFT . I tried put two DFT in sequence containers but since the two DFT uses same variables , I get errors.

    Any different approach? to run DFT in parallel and also use same variables?

    Also attached is my Data Flow diagram of package.

    Thanks.

  • May 31, 2016 at 2:11 pm

    #1882272

    komal145 (5/31/2016)

    hi,

    Is there a way that I can tell ssis to run first DFT and then second DFT . I tried put two DFT in sequence containers but since the two DFT uses same variables , I get errors.

    Any different approach? to run DFT in parallel and also use same variables?

    Also attached is my Data Flow diagram of package.

    Thanks.

    Create a precedence constraint from DFT1 to DFT2.

    Or use different variables, if you want to maintain parallelism.

  • May 31, 2016 at 2:38 pm

    #1882279

    I tried putting precedent constarintsa from DFT1 to DFT2. It did not work as they both same variables and in same loop , the variables values are not assigned properly to the DFT. which caused to load incorrect data .

  • May 31, 2016 at 3:33 pm

    #1882292

    Ok. What are you using the variables for? Are you updating them in the DF tasks, or just reading them?

  • June 2, 2016 at 3:06 pm

    #1882954

    It got resolved using sequence conatineters for each data flow task.

    Thanks again.

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

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