decision making on the basis of script task output

• vaseem-773819

  Ten Centuries

  Points: 1015

  More actions

  December 12, 2008 at 8:49 am

  #125754

  Hi,

  I have a script task in which I have multiple outcomes, suppse 3

  if output 1 then I need to perform task1

  if output 2 then I need to perform task2

  if output 3 then I need to perform task3

  How can I link multiple task to same script task on the basis of output.

  can anybody help me.

  vaseem

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  December 12, 2008 at 10:09 am

  #911762

  You can accomplish this using package variable. After you setup a constraint between two tasks, double click on it and define evaluation operation to expression. The expression will point to the variable used to control the flow.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/