how to use database mail from SSIS 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
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.