arrita arrita - 1 year ago 73
SQL Question

Pull a set of data through stored procedure and send an email

I need to pull a set of data about users THROUGH a stored procedure and send an email to each of them on certain days. Using SSIS, what tasks I can use to do this? I CAN NOT USE Send Mail Task as I don't have access to a local SMTP server.

Answer Source

Send Mail Task can talk to external/third-party mail servers. SMTP Connection Manager's SMTP server setting can be set to any valid Internet/intranet host name (external or internal). However, there's a catch: the SMTP Connection Manager's only authentication option is for Windows authentication. Most external SMTP servers require username/password authentication. talks about several ways to bypass this limitation.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download