Sequance Container Condtional Control Flow
Good day, i have been stuck with this about a day putting my other thread on hold. In a Sequence Container I have 4 Data Flow Tasks, ControlFlow Task1 - Task2 - Task3. I now have a scenorio where after Task1 when a certain var is not Zero Then Execute Task4 before Task2. Well i can determine the flow from Task1 to Task2 or Task4 using Constraint expressions. Well i end up with: Var = 0 then Task1 - Task2 - Task3 Var = 1 then Task1 - Task4 The problem is that i need to Execute Task4 before Task2 when Var!=0 but cant really get it right. Task1,2 & 3 always gets executed - i just dont know how to execute Task4 before Task2 if Var!=0. I know i can make a copy of Task2,Task3 & use Constraint Expression after Task1 which direction to go but I much more Task & only using the 3 tasks to explaining it easier. Please Assist.
January 22nd, 2011 10:37am

Good day All, Solution: http://consultingblogs.emc.com/jamiethomson/archive/2005/07/27/SSIS_3A00_-Affect-control_2D00_flow-with-a-sequence-container.aspx Regards
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 11:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics