StrataFrame Forum

Question about order of execution in SSIS....

http://forum.strataframe.net/Topic9291.aspx

By StarkMike - 6/4/2007

Here is a screen shot of my data flow task...







How do I set the order of execution for each of these? Let's say I wanted the group labeled Source 2 to go first and then the group labeled Source 1 to go second, etc?



Thanks
By StrataFrame Team - 6/5/2007

I found this under the SQL Server Books Online documentation for "Data Flow Tasks [Integration Services]"

A Data Flow task can include multiple data flows. If a task copies several sets of data, and if the order in which the data is copied is not significant, it can be more convenient to include multiple data flows in the Data Flow task. For example, you might create five data flows, each copying data from a flat file into a different dimension table in a data warehouse star schema.

However, the data flow engine determines order of execution when there are multiple data flows within one data flow task. Therefore, when order is important, the package should use multiple Data Flow tasks, each task containing one data flow. You can then apply precedence constraints to control the execution order of the tasks.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/c27555c4-208c-43c8-b511-a4de2a8a3344.htm

Looks like you'll need to split up your data flow task into several and set the precedence on each of them to get them in the order you wan them to be executed.