none
How to execute data flow task based on multiple input data flow from Expression Task. RRS feed

  • Question

  • Hi

    Is it possible to execute the data flow task based on multiple Expression task. The expression task contains the source query variable var_srcquery and a dynamic query assigned here  at runtime. There is 4 Expression Task all assigning to the same variable var_srcquery  based on the condition in the precedence constraint. At a time only one Expression task will execute and go to the data flow task as shown in the picture.

    When i execute the package it correctly building the dynamic query and getting assigned to the variable var_srcquery  but it is not going to the Data flow task.

    Is the Data flow task accepts only 1 input flow.

    is there any other way to handle this, please let me know.

    Thanks



    DD

    Saturday, November 9, 2019 12:47 AM

All replies

  • Solved...Put all the expression task in the sequence container and then connected to the data flow task...It's worked.

    DD

    Saturday, November 9, 2019 8:01 AM
  • Solved...Put all the expression task in the sequence container and then connected to the data flow task...It's worked.

    DD

    Since you have solved your problem by yourself, please kindly close the thread by marking your reply as answer.

    Thanks for your cooperation.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, November 11, 2019 5:34 AM