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?