Lynn Pettis (4/2/2012)

---

Lowell (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

SSIS shouldn't have anything to do with Database Mail.

What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS. I was unware the Database Mail used CDONTS. I thought it used SMTP to communicate with a mail server to send emails.

Am I missing anything here?

There's a bigger picture here, it's hard to track;

Wesh Corgi added a new server, and database mail's not working on the new server, but is fine on many of his other servers; he had a couple of other threads where he was wrestling with trying to get it to work.

this thread is an attempt to get any kind of email working, clearly out of frustration, as he moved off of db_mail and is trying cdonts as an alternative.

Any chance of getting these consolidated so that we aren't flailing around trying to figure out what is going on?