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
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
Try this article Sending email from SQL Server Integration Services (SSIS)