Loading Multiple CSV Files as per the criteria in SSIS...
Creating two variables
ForEach Loop Container
DFT
Script Task
Precedence Constraint (Condition you need mention in Expression)
------------------------------------------------------------------------------
string file = Dts.Variables["User::FilePath"].Value.ToString();
int recordcount = System.IO.File.ReadAllLines(file).Length;
Dts.Variables["RecCnt"].Value = recordcount;
