SSIS:发送邮件任务在计划时不起作用 [英] SSIS: send mail task doesn't work when scheduled

问题描述

我制作了一个简单的程序包，用于创建xls文件并将其发送到电子邮件中.
如果我在BIDS上运行它可以正常工作，我会收到带有附件的电子邮件，如果我在Management Studio内右键单击它可以运行，如果我创建了一个计划包的作业，则该作业/程序包运行良好，但是我没有收到电子邮件，我仅收到一切正常的通知邮件.

我哪里出问题了?

一切都在Windows 2003 R2 Standard Edition SP2和SQL Server 2008 R2 SP1上进行

更新
我发现以发送邮件任务"发送的电子邮件已到达我的邮件服务器，但它们在SMTP队列中停止，并出现一般错误:

Thu 2012-05-10 10:26:08:套接字错误发送了对DATA的响应
周四2012-05-10 10:26:08:* Winsock错误10054 Connessione reimpostata dall''altro lato.
Thu 2012-05-10 10:26:08:SMTP会话终止(字节输入/输出:152315/382)

有任何想法吗?

I made a simple package which create an xls file and send it attached to a email.
If I run it inside BIDS it works, I received email with attachment, if I run it right-clicking inside Management Studio it works, if I create a job to schedule package, the job/package runs well but I don''t receive email, I receive only notification mail that everything went ok.

Where I go wrong?

Everything is on windows 2003 R2 Standard Edition SP2 and SQL Server 2008 R2 SP1

update
I found that emails sended with "send mail task" arrived in my mail server but they stopped in SMTP in queue with a generic error:

Thu 2012-05-10 10:26:08: Socket error sending response to DATA
Thu 2012-05-10 10:26:08: * Winsock Error 10054 Connessione reimpostata dall''altro lato.
Thu 2012-05-10 10:26:08: SMTP session terminated (Bytes in/out: 152315/382)

any ideas?

推荐答案

确保发送电子邮件的SMTP服务器已正确设置.使用Windows SMTP服务器的NTLM身份验证发送电子邮件，这意味着用于运行任务的安全凭据也必须在SMTP服务器上具有特权才能发送电子邮件.如果SMTP服务器不是基于Windows的服务器，则如果该服务器允许匿名访问，则将发送电子邮件.

SMTP服务器安装程序位于: http ://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e4cf06f5-9a36-474b-ba78-3f287a2b88f2.mspx?mfr = true [

Make sure the SMTP server that sends the e-mail is setup correctly. E-mail is sent using NTLM authentication for Windows SMTP servers, which means that the security credentials used for running the task must also have privileges on the SMTP server to send e-mail. If the SMTP server is a non-Windows based server, then the e-mail will be sent if the server allows anonymous access.

SMTP server setup is available at: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e4cf06f5-9a36-474b-ba78-3f287a2b88f2.mspx?mfr=true[^]

感谢您的回答.
我以同时运行引擎和代理的用户身份登录服务器，该用户是domai用户，并且是本地管理员，因此我可以交互"发送邮件，因此我认为SMTP服务器已正确设置，但按之前所说的计划进行时，请不要这样做.不发送.

再次感谢再见

Thanks for your answer.
I logged on to my server with user which runs both engine and agent, which is a domai user and is local adminstrator, and I can send mail "interactively" so I think that SMTP server is properly setup but when scheduled as said before don''t send.

Thank again bye

我认为这是mdaemon发送电子邮件任务之间的问题，该任务关闭了快速连接，因此我使用了此解决方案

I think it''s a problem between mdaemon send email task which close the connection to fast so I''ve used this solution Send Email from SSIS with option to indicate Email User and Password[^] placing this statement, System.Threading.Thread.Sleep(5000), after method .send giving the time to email to be sent.

I hope it could be useful for someone else and sorry for my english

这篇关于SSIS:发送邮件任务在计划时不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！