Read EmailTo,EmailFrom,Subject and Body From Text File and Send Emails by using Send Mail Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

Scenario:

Let's think about a scenario where we have provided permission to business users to update text file or excel file with email to , email from , subject and body. They can make changes to all day long and at the end of the day we use that file to send emails as per contents of the file by using Send Mail Task in SSIS Package.

Solution:

In this video we will learn how to solve above scenario by using below components of SSIS Package
How to read flat file records with information such as Email to, Email From, Subject and Body into Object Type variable
How to read one record at a time from Object type variable by using For-each Loop Container
How to store values into variables in For-each Loop Container
How to use Variables in Expressions in Send Mail Task in SSIS Package



How to read Email information from Flat file and Send Email by using Send Mail Task in SSIS Package - SSIS Tutorial


  Related Posts/Videos on Send Mail Task