SQL Server Performance

Batch table update

Discussion in 'SQL Server 2005 Integration Services' started by Godai, Aug 18, 2006.

  1. Godai New Member

    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 ?
  2. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page