asked
Send Mail based on Data Count Condition
I want to set up a task that will run a select count(*) query from a table and if count > 0, then send email to team.
Hi , you can have a execute sql task which will return the count .Map this count value to a variable.The using the precedence constraints you can decide whether to execute the send mail task or not .You can write the expression like @variable > 0 You can also use the variable value(the count) in your send mail task. Hope this helps .
3 People are following this question.
