SSIS: how to send an email if a stored procedure returns a certain value
I would like to be able to run a SQL task that runs a stored proc. The proc returns 0 or 1. If it r开发者_如何转开发eturns 1 then email.
Store the execution result from the stored procedure in a variable. Add a send mail task and edit the precedent constraint expression to evaluate the result of the variable which then conditionally executes the send mail task.
精彩评论