Blog on SQL Server, Business Intelligence and the Cloud

Send Emails in SSIS Using Task Factory's Advanced Email and SMS Task

Written by Ken Wood | Mar 16, 2016

The Advanced Email and SMS Task from Task Factory is more than just a tool used to send Emails and SMS Text Messages with SSIS. As the name suggests, it’s “Advanced”; of course we can do more with the Advanced Email and SMS Task

One of the more advanced features of the component is the ability to send customized email details to everyone on your email list. It’s as simple as configuring a few variables and executing.

Here’s the problem we want to solve today.  

Let’s say a business weeds through a long list of updated client information every couple of weeks. It may very well be too daunting a task to go through every single customer detail and customize a response specific to the client that can be emailed out. Usually the alternative is to send a mass email to the clientele in hopes they may not find it too generic, but instead find it agreeable and respond in kind with their business.


This problem is solved quickly and efficiently with our Task Factory Advanced Email and SMS Task! 

Your list may be thousands and thousands of rows in length; to that we say, “Great! Bring it on!” To how to send customized, mass email in SSIS using Task Factory, please see the brief demo video laid out for you below.