I created a package in SSIS to export data from mutiple SQL server tables to a single flat file. Once the export is completed i need to update 2 tables ( a batch table and a history table) In the batch table I need to insert a record with batch # (system generated),batch date, status( success/failed), record count( no of records in the flat file), batch filename). In the history table, i need to insert a record for each of the rows in the flat file with the foll info. batch number,datetime,status(success/failed) My question is how do I get the batch status,record count, batchfilename for batch table update and how do i get to update the history table. BTW, i am executing this package as a SQL Server Agent job. I am new to Integration Services and feel lost. Any help ?