March 26, 2015 at 10:33 pm
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
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 27, 2015 at 2:21 am
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
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply