How to retrieve files from folder and records from Table by using ForEachLoop Container:-

How to retrieve files from folder and records from Table by using ForEachLoop Container:-
Hi,
By using ForEachLoop Container we can repeat loop and send all files to execution.
1.For Each File Enemurator – Files from Folder
a.In the Collection tab first we can browse file folder and we can set the files along with extension like Screen 1.
b.we can set the variable in the Variablemapping tab,this variable will read the file names one by one from the loop like Screen2.
Screen1

Screen2

2.For Each ADO Enemurator – Records from Table
a.First we can select the columns from the table using ExcecutesqlTask,and we can assign these values to local variables and fullresultset to a system.Object Type variable like Screen 1,Screen 2 and Screen 3.
b.In the ForEachloopContainer Collection tab we can select that system.Object Type variable to ADOobjectSource_Variable like Screen 4.
c.We can set the local variable in the Variablemapping tab,this variable will read the columns one by one from the loop like Screen 5.
Screen 1

Screen 2

Screen 3
Screen 4
Screen 5