Tuesday, March 20, 2012

Conditionally execute a task

Hallo

Is there a way to conditionally execute a task?

I got a task “Mail Send“ and I would like to execute it, just if the variable X (my message source) has a value.

I try in expressions “Disable” = len(@.[Benutzer::Msg] ) > 5 ? false : true, but it does not work.

Link with an an arrow the task before send mail task double click the green line and (you have Precedence Constraint Editor window) choose at Evaluation Operation the value Expression and type

@.x is not null or other expression

so if the expression is true SSIS will go and run sendmail task

|||

Following ggciubuc post...

You can add an additional row to a scrit task in order to fail the package if the expression is the oposite of the first expression...

helped?

Regards

No comments:

Post a Comment