Dataflow Tasks execution dynamically

  • Hi All,

    Suppose i have 30 DataFlow Tasks.

    I need to go to the Dataflow task based on the value returnd from ExecuteSQLtask.

    Suppose if i get 5 then i should go to Dataflow task5 directly and there onwrds it executes remaining tasks continusoly.

    Thanks in advance...

  • you could map the results of your execute SQL task to a variable, and then use this varaible as part of an expression in the precendnce constraint for each dataflow.

  • I completely agree.

    CEWII

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

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