SSIS 发送有关错误的电子邮件发送多个错误

本文介绍了SSIS 发送有关错误的电子邮件发送多个错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个简单的 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 <;1;计数 = 计数 + 1.

Used for loop container, declared variable Count with value = 0 and in for loop container set the condition Count < 1; Count = count + 1.