Click here to Skip to main content
14,876,268 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
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
Updated 9-May-12 22:35pm
v2
Comments
bbirajdar 8-May-12 9:23am
   
Reason for my vote of 1
Not clear

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

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900