ssis 发送邮件任务:错误:发生错误并显示以下错误消息:“操作已超时." [英] ssis send mail task: Error: An error occurred with the following error message: "The operation has timed out."

问题描述

有问题的 SSIS 包运行一系列存储过程并用结果填充 13 个不同的 excel 文件，并将这些 excel 文件以附件形式发送给 13 个不同的用户.包运行停止并显示此问题标题中的消息，某个时间正好在发送中间，例如今天，在第 4 个用户处.创建文件是因为我可以在它们的目录中看到它们，因此只有发送邮件任务失败.当我回到visual studio并手动执行每个发送任务时，发送任务工作正常，即使有时它仍然给我错误，仍然将正确的文件发送给正确的人，但不是通过在SQL服务器中运行的SSIS包......我试图延迟 SMTP 进程，认为这可能会妨碍(到 660000 毫秒)，但没有帮助.有人遇到过这种情况吗? .. 提前感谢您的所有回答.

SSIS package in question runs a series of stored procedures and fills 13 different excel files with results and sends those excel files to 13 different users in attachments. Package run stops with the message in the title of this question, sometime right in the middle of sending or for example today, on the 4th user. The files get created because I can see them in their directories so only the send mail task is failing. When I go back to visual studio and execute each send task manually, send task works fine even though sometime it still gives me the error yet, still sends the right file to the right person but not thru SSIS package run in SQL server... I tried to delay SMTP processes thinking that might be in the way (to 660000 miliseconds) but did not help. Has this happened to anybody?.. Thanks for all your answers in advance.

这是一个任务的完整消息，该任务发送了带有附件的电子邮件，而不管手动执行任务时的错误...

Here is the full message for a task that sent the e-mail with attachment regardless the error when task was manually executed...

[Send Mail Task] Error: An error occurred with the following error message: "The operation has timed out.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task for Inventory Reports 038 failed
Finished, 12:03:03 PM, Elapsed time: 00:00:00.655

推荐答案

我想我明白为什么会发生这种情况了.如果有人/任何人感兴趣，这就是我认为已经发生的事情.我试图通过脚本任务扩展超时时间，使用 Threading.Thread.Sleep 值，但我忽略了在我的 SMTP 连接属性中做同样的事情.当我更改 SMTP 连接属性中的超时值时，错误消息不再出现:)

I think I figured it out why this was happening. In case somebody / anybody is interested, here is what I think has happened. I was trying to expand the timeout period thru a script task, playing with Threading.Thread.Sleep value but I neglected to do the same in my SMTP connection properties. When I changed the timeout value in properties for SMTP connection, error messages stopped coming :)

我希望我可以发布一张图片来向您展示该物业的确切位置，但我的声誉让我失望！.. :((还不到 10 分)

I wish I could post a picture to show you where exactly that property is located but my reputation failed me!.. :( (less than 10 points yet)

我正在完成所有更改，然后我将再次发布最终结果，希望能解决我所有的问题.

I am in the process of completing all of my changes then I will post again with final result hoping that will resolve all of my problems.

感谢所有表现出兴趣的人.

Thanks to all who showed interest.

这篇关于ssis 发送邮件任务:错误:发生错误并显示以下错误消息:“操作已超时."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！