I have to load files into a table using loop in SSIS 2008 ..
And I need to track each process into a 'process_track' table containing the fields - Process_id, Start_time, End_time and Status (processing or completed) ..
Also I need to track the loading Files into a 'File_Track' table containing the fields-
File_id, ProcessTracker_id, File_name, Start_date, End_date and Status..
How can I do this ..? Thanks in Advance .. :)