Log of rows inserted/updated/deleted

HI, I am wondering if it is possible to retreive this information without using row count transform. Can I get the # of rows inserted/updated or deleted by destination from the log?

Thank you,
Ccote

An OnInformation event is raised by the data-flow task when data flows into a destination. This has free text which contains the number of rows. You would have to parse that information out of the text within the OnInformation eventhandler. See here for more details: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=372847&SiteID=1

-Jamie

Log all updated tables

We have a third party process that runs and updated several SQL tables.
Is there any way to find out what tables are being updated and store it in another table?IF you are running MS-SQL 2000, then use SQL Profiler.

-PatP|||I thought of that but they want this to run all the time. And profiler can cause some overhead. Is there any way to view what's in the transaction log?|||My first thought would be Lumigent Log Explorer (http://www.lumigent.com/products/le_sql.html), but there are options involving triggers that could also do what you've described.

-PatP|||You can take help of server side trace, as the PROFILER is a resource intensive operation.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm & KBA http://support.microsoft.com/?kbid=822853