What is Recordset Destination in SQL Server Integration Services(SSIS)

In this video we will learn What is RecordSet Destination and how to use RecordSet destination in real time scenarios.

The video will explain how to read the list of emails from flat file and save them in object type variable by using Recordset destination in Data Flow Task in SSIS Package and finally use Foreach Loop Container to loop through the list of emails from Object Type variable and send email by using Send Mail Task.

Recordset Destination in SSIS Package