Batch table update | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Batch table update

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 ?

Have you searched under Books online for such information, I’m sure that is logged on somewhere within the SSIS properties. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.