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