Send Mail task

Question

Send Mail task

sunny.tjk

SSCertifiable

Points: 5041
More actions
August 5, 2010 at 2:05 pm

#141367

The developers are trying to upgrade the dts packages to SSIS. Instead of using the sP_send_dbmail, they want to use the SendMail task in SSIS. They are asking me for the SMTP connection information to use the SendMail task. Where do I get this?
thanks everyone.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Animal Magic SSChampion Points: 13964 More actions · Answer 1

ask whoever maintains your mail server (assuming you have an SMTP driven mail service). if you dont then there are plenty guides around to use various web mail providers as your database mail provider.

in my company i can connect using basic authentication to exchange so all i need to enter is the IP address

Animal Magic SSChampion Points: 13964 More actions · Answer 2

one other point, using the send mail task just uses sp_send_dbmail in the background anyway, so if they already have the sql code you may as well just use it as an execute sql task in SSIS

Adiga One Orange Chip Points: 27284 More actions · Answer 3

If you already have Database Mail configured, please check the properties of the same. It will contain the SMTP server details.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

sasuke4you SSC Veteran Points: 224 More actions · Answer 4

Adding to Pradeep's reply above, I'm including the path you'd take in the SSMS.

1. Expand the Management node in SSMS and Rt. Click 'Database Mail'.

2. The Wizard opens up and you need to choose 'Manage Database Mail Account and Profiles'

3. Next choose the 'View, Change or Delete an existing account'

4. Look under the Outgoing Mail Server (SMTP) for the "Server Name" entry. This will give you your SMTP server name.

Hope this helps...