I try to use gmail in database mail. I have no problem to send out email from it. But how I can configure my send mail task to send out email by using database mail. Thanks
Sql-server – how to use database mail from SSIS
database-mailsql-server-2008ssis
Best Answer
The SSIS Send mail task connects directly to a SMTP server - it doesn't use database mail. If you want to use database mail, you would invoke it through an 'Execute T-SQL Statement' task that calls a stored procedure that wraps the database mail facility, or something similar.