SSIS Tutorial Part 89.1-Send Names of Files from A Folder as Email by using Send Mail Task

SSIS Video Scenario:

We receive different files in one of the folder. Before we start our loading process, we have a requirement to send all the file names in the email to our team by using SSIS Package.

Solution:

In this video we will be able to solve above scenario, we will be using following components of SSIS Package

How to Create Parameters for Folder Path, EmailTo and EmailFrom
How to use For-each Loop Container to loop through all the file in a folder
How to use ReadOnlyVariables and ReadWrite Variables in Script Task
How to create list of list and save into a variable
How to use Expressions in Send Mail Task for MessageSource( Body), LineTo and FromLine

Link to the post with expressions

Complete SSIS Tutorial by Tech Brothers

[krismaly]

I enjoyed watching this video and recommend others.

Thanks for educaing the community.

Question
How to attach files to email and send?
Is there another video?
or any idea?

Thanks,

[shubhamagarwal]

Great Video...
Sir i have to ask one thing you have used script task to save the name of each file.
Can we use record set destination to save the name of each file in object type variable and later we can use that object variable in send mail task to send the mail across the team members?