Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Send Mail Task

Author  Topic 

sgandhi
Posting Yak Master

115 Posts

Posted - 2009-03-26 : 11:32:38
I am creating a excel file using SSIS. This works fine. Now i want to email the file that is created

But i get this error

Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete

This error is not very helpful.

It doesnt even work even if i dont put a attachment in there.

Can anyone please advise me on what im diong wrong

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-03-28 : 01:00:36
Check SMTP value - use alias name then IP address if alias fails.
Go to Top of Page
   

- Advertisement -