开发者

SSIS: how to send an email if a stored procedure returns a certain value

开发者 https://www.devze.com 2023-02-02 10:52 出处:网络
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

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

精彩评论

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

关注公众号