fyi,
i was capturing all events happening against a Table, I was able to find S/I/U/D etc events for few Phone number
But there was a phone number i was particular about and i couldn't see in Insert ,so with the time it got inserted I see SSIS package doing BULK INSERT.
so, what i learned is if we insert data via ssis or bulk copy/insert we will not see ROW data.
we can see all Statements happening with SSIS or BULK ...
i was capturing all events happening against a Table, I was able to find S/I/U/D etc events for few Phone number
But there was a phone number i was particular about and i couldn't see in Insert ,so with the time it got inserted I see SSIS package doing BULK INSERT.
so, what i learned is if we insert data via ssis or bulk copy/insert we will not see ROW data.
we can see all Statements happening with SSIS or BULK ...
No comments:
Post a Comment