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  

• Create Load Summary Email logic in SSIS Package
• How to Configure Send Mail Task and Send Email in SSIS Package
• Create a file with Date From SQL Server Table and Send as Attachment in SSIS Package 
• Attach Multiple Files Dynamically in Send Mail Task in SSIS Package
• Send Error Email with Error Code, Error Description by using Send Mail Task in SSIS Package 
• Send List of Files from A Folder as Email by using Send Mail Task
• Use Send Mail Task with Precedence Constraints in SSIS Package
• Read Subject,Recipient and Body from SQL Server Table and Send Email by Using Send Mail Task 
• Send Load Summary Email by using Send Mail Task in SSIS Package