Sending Mail Using SSIS

Question

Hi All,

 

I've been trying to figure out how to send mails using SSIS 'Send Mail Task' and 'Script Task' with no success. My email client is Microsoft Outlook 2007. If I'm using the Send Mail Task, in Mail>New SMTP Connection, what would be my SMTP server. Do I need to use Windows Authentication. By the way, I'm using SSIS 2008 R2. If you cannot tell me my SMTP server, please let me know how I can find the same in my machine. I tried running some scripts found from google but every time the Script task is complaining that binary code is not found and to edit it. So please help me in sending mails either using Send Mail Task or using Script Component.

 

Thanks in advance!

Answer 1

In either case of using a Script Task with System.Net or the Send Mail task, you will need the SMTP server to send the email message.  You will need to contact your system administrator or Exchange Admin for the name or IP address of your SMTP server.  Depending on how your SMTP server is set up, you might not need to submit a username  and password.  Again, your administrator will assist you with this.

Regards,

John

Answer 2

1)      Whether it is Send mail task or script task , SMTP server has to be installed on the machine.

2)      To install SMTP server IIS is required.

3)      SMTP needs to be installed on top of IIS.

4)      Please check http://msdn.microsoft.com/en-us/library/8b83ac7t.aspx

---

Happy to help! Thanks. Regards and good Wishes, Deepak.

Answer 3

An SMTP server is required - but you should be able to find that information by looking at your Outlook mail settings.  Go to Tools|Accounts, select your account and "change" it.  Look for the SMTP or "outgoing mail" server setting.  That's your SMTP server URL.

---

Talk to me now on

Answer 4

Thanks a million Todd!!! That really helped :-)

Much appreciated....

 

Sharath