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?

  • 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.

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

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