Hello gyues, I am working on a project in which I'm creating a datawarhouse using 4 data sources, one for each country. (c1, c2, c3, and c4) . In my TAc I have created 4 execution plans one for each country and every single one of them contains a bunch of specific tasks. . i want to schedule the 4 execution plans one after the other, if the first one is finished then the second one should start and when it finishes it triggers the third execution plan until the last one, but I noticed that there is no AddOnOk option between execution plans, any suggestion please?
Hi
Yes, the trigger type such as Add onOK cannot be used at the plan level, you can't control the execution order of plans. Maybe you can consider creating different tasks for each country, so that just create one plan to contains these 4 tasks and control the execution order of tasks.
