Write Script not to do next action

• tomoko667

  SSC Enthusiast

  Points: 195

  More actions

  September 26, 2008 at 4:48 am

  #127810

  hi,

  Im new to writing a script task.

  There are two items inside of the foreach loop, Script Task and DataFlow.

  Inside of the script task, there is a if statement.

  if the variable "Num" equals to "1", I want SSIS to excecute the next item, DataFlow.

  If "Num" is "2", I want SSIS to skip Dataflow and come back again in Foreach loop.

  does someone have any idea how I should wirte these code above??

  Help me Please.

  thank you,

  tomoko

• hodgy

  SSCertifiable

  Points: 5906

  More actions

  September 26, 2008 at 5:49 am

  #877568

  you could use the script as a dummy task (i.e. it does nothing) and have a constraint between the script and the data flow which uses an expression.

  then, in the expression, you check the contents of your variables.

  Life: it twists and turns like a twisty turny thing