Send Mail Task

Question

Send Mail Task

reachnaidu

Valued Member

Points: 61
More actions
April 7, 2008 at 7:15 pm

#154265

I am trying to use Send Mail Task in SSIS and having issues with that. Looks like I didn't configured my SMTP service in my system properly...
Could any one help me with SMTP configuration.....
Thanks in advance.....

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

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

Brandie Tarvin SSC Guru Points: 173116 More actions · Answer 1

Does it look like a Connection Manager issue?

If so, go to connections. Choose New Connection->SMTP (Connection Manager for the Send Mail Task). A popup box will appear. On the "SMTP Server:" box (third from the top), enter your SMTP server. The way I have mine listed is (ServerName).(DepartmentDomain).(MiddleDomain).(TopDomain).com.

I also have "Use Windows Authentication" checked, but not SSL.

If you don't know the address of your SMTP Server, check with your network / Server team and ask them.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

reachnaidu Valued Member Points: 61 More actions · Answer 2

Thanks a lot Brandie Tarvin for your detailed reply ..its working now..

Brandie Tarvin SSC Guru Points: 173116 More actions · Answer 3

Glad I could help. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.