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?
I only mentioned SSIS because I suspect something weird is going on with that Server.
I just want to test CDONTS to see if it worked not as an alternative to DB Mail.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/