Does the Database Mail Task in SSIS use Database Mail?

Question

Does the Database Mail Task in SSIS use Database Mail?

Welsh Corgi

SSC Guru

Points: 116520
More actions
December 15, 2011 at 1:08 pm

#391143

Does the Database Mail Task in SSIS use Database 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/

Viewing 10 posts - 1 through 9 (of 9 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

It doesn't use sp_send_dbmail if that's what you mean.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Doesn't is use SMTP 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/

Pyman SSChampion Points: 13830 More actions · Answer 3

I think once you specify the SMTP server name/Ip address it should use the SMPT server.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Please confirm whether or not the SSIS Send mail Task is or is not related to Database Mail.

Correct me if I'm wrong but the Send Mail Task does not use Database 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/

GSquared SSC Guru Points: 260824 More actions · Answer 5

It does not use SQL Server Database Mail.

It does use SMTP. But so does Database Mail. SMTP is simply the mail transfer method ("Simple Mail Transfer Protocol" is what it stands for), and it's the basic standard for all e-mail transmission. POP and IMAP are pull methods of getting e-mail from a server, but SMTP is pretty much the method for pushing e-mail to servers and between servers.

However, if all you want to know is does SSIS use Database Mail, the answer is no. Nor does it use the old SQL Mail that SQL 2000 used before DBMail.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

@GSquared,

That is what I thought and I was trying to convince someone that just because their Send Mail Task Starting working it had nothing to do with Database Mail which is not enabled.

They thought someone turned Database mail on which was not the case.

Thank you.

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/

Lowell SSC Guru Points: 323518 More actions · Answer 7

i'm pretty sure it's simply using the .NET classes System.Net.Mail.SmtpClient and System.Net.NetworkCredential to send any emails;

in .NET, it's pretty simple to use that to send an email.

this is how i've done it in VB.Net, so i'd assume SSMS is doing the same.

Dim strFrom As String = "lowell@somedomain.com"

Dim strTo As String = "lowell@somedomain.com"

Dim strSubject As String = "Phone Text"

Dim strBody As String = Me.txtPhoneMessage.Text

Dim strSMTPServer As String = "mail.somedomain.com"

Dim strSMTPUser = "lowell@somedomain.com"

Dim strSMTPPass = "NotARealpassword"

'send the email

Try

SendEmails = False

For Each phone As String In PhoneNumbers

If phone.Trim.Length = 0 Then Exit For

If phone.Substring(0, 1) = "1" Then phone = phone.Substring(1, phone.Length - 1)

phone = StripNonNumeric(phone)

If phone.Length <> 10 Then Exit For

strTo = phone & "@txt.att.net"

Dim message As New System.Net.Mail.MailMessage(strFrom, strTo)

message.Subject = ""

message.Body = Me.txtPhoneMessage.Text

message.IsBodyHtml = False

Dim emailClient As New System.Net.Mail.SmtpClient(strSMTPServer)

Dim SMTPUserInfo As New System.Net.NetworkCredential(strSMTPUser, strSMTPPass)

emailClient.UseDefaultCredentials = False

emailClient.Credentials = SMTPUserInfo

Try

emailClient.Send(message)

Catch ex As Exception

MsgBox(ex.Message)

End Try

Next

SendEmails = True

Catch e As Exception

SendEmails = False

Console.WriteLine(e.Message)

End Try

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ChrisM@home SSC-Insane Points: 24260 More actions · Answer 8

GSquared (12/15/2011)
It does not use SQL Server Database Mail.
It does use SMTP. But so does Database Mail. SMTP is simply the mail transfer method ("Simple Mail Transfer Protocol" is what it stands for), and it's the basic standard for all e-mail transmission. POP and IMAP are pull methods of getting e-mail from a server, but SMTP is pretty much the method for pushing e-mail to servers and between servers.
However, if all you want to know is does SSIS use Database Mail, the answer is no. Nor does it use the old SQL Mail that SQL 2000 used before DBMail.

Spot on. Nor are the events recorded in the system tables used by DBmail.

[font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

For better assistance in answering your questions, please read this[/url].

Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 9

GSquared (12/15/2011)
It does not use SQL Server Database Mail.
However, if all you want to know is does SSIS use Database Mail, the answer is no. Nor does it use the old SQL Mail that SQL 2000 used before DBMail.

That is good to know.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP