Is SSIS Send Mail task using SQL Mail only?

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  April 3, 2012 at 4:43 am

  #254251

  Hello,

  We are using SQL 2008 R2. As per the current requirement, we need to send email as per SSIS package execution.

  I know we need to use SQL Mail or SSIS Send Mail task for sending the email.

  I would like to know - Is SSIS Send mail use SQL Mail feature only (means internally) ?

  What is pros & cons to use SSIS Send Mail task?

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442333

  More actions

  April 3, 2012 at 9:04 pm

  #1468611

  The SSIS Send Mail Task uses SMTP for semding emails. I haven't used it but it should be fairly stable to use.

• SQLRNNR

  SSC Guru

  Points: 281243

  More actions

  April 3, 2012 at 9:10 pm

  #1468613

  DB Mail does not need to be configured in order to use the SSIS send mail task.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  April 3, 2012 at 9:53 pm

  #1468620

  Thanks for your response.

  I would like to know - Is SSIS Send mail use Database Mail feature only (means internally) ?

  What is pros & cons to use SSIS Send Mail task?

  Thanks

• SQLRNNR

  SSC Guru

  Points: 281243

  More actions

  April 3, 2012 at 10:09 pm

  #1468622

  No SSIS Send mail does not use Database mail internally.

  As far as pros cons - it's 6 in one half a dozen in the other. They are equal in my opinion.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• Koen Verbeeck

  SSC Guru

  Points: 258965

  More actions

  April 4, 2012 at 4:42 am

  #1468710

  Hardy21 (4/3/2012)

  ---

  Thanks for your response.

  I would like to know - Is SSIS Send mail use Database Mail feature only (means internally) ?

  What is pros & cons to use SSIS Send Mail task?

  You can use database mail in SQL Server Agent, to notify people if jobs have failed. It's pretty easy to configure. It's a bit easier in database mail to append result sets of queries to the e-mail and e-mails with HTML are also a bit of a challenge in SSIS, but everything can be done.

  As said before, there are no real differences.

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