Scenario:
We have multiple files in one of the folder, we need to create an SSIS Package that can attach all the files from that folder and send to required recipients.
Solution:
In this video we will learn how to send multiple files as attachment in SSIS Package by using Send Mail Task. We will also learn below components as part of solution
- How to Create SSIS Package Parameters
- How to use Foreach Loop Container to Loop through Files in a Folder
- How to use Variables in SSIS Package to build attachment list
- How to use Send Mail Task in SSIS To send Multiple File Dynamically
- How to use Expressions in Send Mail Task in SSIS Package
Code used in the Script Task in this video
Dts.Variables["User::Attachment"].Value = Dts.Variables["User::Attachment"].Value +
Dts.Variables["User::FileFullPath"].Value.ToString() + "|";
How to send Multiple Files as Attachment 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
- 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
- Read EmailTo,EmailFrom,Subject and Body From Text File and Send Emails by using Send Mail Task in SSIS Package
- Send Load Summary Email by using Send Mail Task in SSIS Package
No comments:
Post a Comment