Question about order of execution...

[bmgmzp]

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?

 

[mrdenny]

You have to put each data flow into it's own data flow task, then set success/completion presidents between the data flow tasks.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com