Running different tasks inside for each loop depending on input variable

• lbob

  SSC Enthusiast

  Points: 109

  More actions

  May 14, 2009 at 4:05 am

  #130865

  Hi

  I'm a SSIS newbie so please bear with me.

  I've got a for each loop container that I'm using to enumerate an xml file. If the variable is "Y" then I want it to do a specific task, if it's "N" then I want it to do something else.

  I initially set it up as a Script task and stated if the variable = "Y" then it was a success and carried on, if it was "N" then it failed and did the separate task, but it doesn't carry on enumerating the file after it finds the first "N".

  Is there a better way of doing this?

  Cheers

  Lbob

• TheFoo

  SSChasing Mays

  Points: 636

  More actions

  May 14, 2009 at 4:41 am

  #994361

  You can use expressions in the precedence constraints to read the value of the variable and split the control flow depending on the variable's value.

  Format for expression:

  (@VariableName)=="Y"

• lbob

  SSC Enthusiast

  Points: 109

  More actions

  May 14, 2009 at 7:33 am

  #994500

  Thanks, it worked a treat.

  Lbob