Post reply

How to log the source count , inserted count and updated count in to log table

  • March 26, 2015 at 10:33 pm

    #306169

    Hi ,

    I am working on SSIS package where I have to implement logging for records count.

    In my package I have 20 Data Flow Task, now my requirement is to log the source count , inserted count and updated count in to log table.

    please suggest me how can achieve this

    regards,

    Vipin jha

  • March 26, 2015 at 11:45 pm

    #1786743

    vipin_jha123 (3/26/2015)

    Hi ,

    I am working on SSIS package where I have to implement logging for records count.

    In my package I have 20 Data Flow Task, now my requirement is to log the source count , inserted count and updated count in to log table.

    please suggest me how can achieve this

    regards,

    Vipin jha

    Which method are you using to perform the inserts and updates?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • March 27, 2015 at 2:21 am

    #1786769

    I have conditional split

    one output is new which will insert into target table directly using OEDB Destination

    another output is Updated which will update the existing record, I am using oledb command for same

    regards,

    Vipin jha

  • March 27, 2015 at 2:50 am

    #1786774

    Then it becomes very easy – use multiple Rowcount transformations to capture the counts in the DF and then write those variables out to your logging table using a subsequent ExecuteSQL task.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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