Post reply

Is SSIS Send Mail task using SQL Mail only?

  • 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

  • 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.

  • 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

  • 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

  • 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

  • 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

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

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