开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜