April 3, 2012 at 4:43 am
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
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
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
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy