load files into a table using loop in SSIS 2008 -

load files into a table using loop in SSIS 2008 -

i have load files table using loop in ssis 2008 .. need track each process 'process_track' table containing fields process_id, start_time, end_time , status (processing or completed) .. how can ? in advance ...

in broad strokes, want loop in command flow, manipulates variable can utilize in look determines connection string of flat file connection manager. in loop, have info flow task moves info around, 'execute sql statement' task writes update process_track table.

ssis