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
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)