snippetMinor
how to use database mail from SSIS
Viewed 0 times
fromssisdatabasemailhowuse
Problem
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
Solution
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.
Context
StackExchange Database Administrators Q#16362, answer score: 2
Revisions (0)
No revisions yet.