SSIS: send mail task doesn't work when scheduled

Question

3.00/5 (2 votes)

See more:

SQL-Server-2008

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?

Posted 7-May-12 23:32pm

ste263

Updated 9-May-12 22:35pm

v2

Add a Solution

Comments

bbirajdar 8-May-12 9:23am

Reason for my vote of 1
Not clear

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2012-05-08T09:07:00

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[^]

ste263 · Answer 2 · 2012-05-08T19:58:00

Solution 2

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

Posted 8-May-12 19:58pm

ste263

ste263 · Answer 3 · 2012-05-10T20:02:00

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: send mail task doesn't work when scheduled

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0