Post reply

How To Log SSIS package each step results to a table

  • May 5, 2010 at 10:37 am

    #146920

    Hello All,

    in my ssis package, i have 7 data flow tasks in it (which is basically loads data to the target tables),

    how can i write a log record to a table after each dataflowtaskcomplete

    Logtable will be look like

    ID,DateTime, DataFlowtaskName, Result,Description

    1,5/4/2010 11:26:00, Success,inserted 200 records to table RegionAccountStatus

    1,5/4/2010 11:26:00, Success,updated 21records in table CityAddress

    1,5/4/2010 11:26:00, Error, primary key voilation

    1,5/4/2010 11:26:00, Success,No Records Found

    please suggest me what are the possible ways,

    Please to allll

    Thanks a ton in advance

    Asita

  • May 5, 2010 at 1:57 pm

    #1162758

    Maybe you can write a SQL Task that calls a stored proc which will do the count of records inserted in the Daa Flow task and populate the results of the counter into another table which stores only the summary.

    I have done something similar but not close to what you need.

    Rex Smith

  • May 5, 2010 at 4:49 pm

    #1162870

    thanks rex for your idea, i will try that and let you know once i done

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply