问题描述
我有一个简单的 SSIS 包，我在其中创建了发送电子邮件任务以发送错误详细信息的 On Error 事件处理程序.但是我收到多封电子邮件，因为一个错误.我找到了将所有电子邮件分组的方法，但它们是在 vb 脚本中，而我的 SQL 服务器是 64 位，这反过来需要安装修补程序以进行二进制编译.所以我需要任何替代选择.即使我可以发送第一个错误电子邮件并忽略其他电子邮件，我也没关系.任何建议将不胜感激.
I have simple SSIS package in which On Error event handler I have created Send email task to send error details. But I get multiple emails for one error. I found the ways to club all emails but they are in vb script and my SQL server is 64 bit which in turn requires hotfix installation for binary compilation.So I need any alternative option for that. It's fine with me even though I can send first error email and ignore other.Any suggestion will be appreciated.
推荐答案
我找到了满足我发送第一个错误并忽略其余要求的解决方案.
I found the solution which meet my requirement of sending first error and ignoring rest.
用于循环容器，声明变量 Count，值为 0，在 for 循环容器中设置条件 Count
Used for loop container, declared variable Count with value = 0 and in for loop container set the condition Count < 1; Count = count + 1.
这篇关于SSIS 发送有关错误的电子邮件发送多个错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！