Is SSIS Send Mail task using SQL Mail only?

  • Hardy21

    SSCrazy Eights

    Points: 9708

    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: 442335

    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

    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

    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

    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

    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

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

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