Using Row Count

Pardon my ignorance, but does someone have a step by step guid to include row count transformation in a package.

What I want to do is to count the number of rows extracted from the source and the number of source inserted to the target.

I have tried to include a row count transformation with a variable defined. But the variable keeps showing 0 after each run

Simon M
The issue you may be encountering is when did you check the variable value The run-time value will not be visible post execution (as it would have been with DTS global variables). A simple check is to set a break-point on the Post Execute event of the Data Flow Task in question. When the break point fires, open the Variables tool window, and the Watch tool window. Drag the variable from Variables to Watch. You should now see the real runtime value. You would normally use a second task to log these variables somewhere, perhaps an Execute SQL Task to log them into a table for example, for audit/history purposes.
Darshan Pandit
Thanks Jamie for this very useful blog on rowcount - http://blogs.conchango.com/jamiethomson/archive/2005/05/29/1487.aspx

Hope this helps.

Thanks,
Loonysan
Using Row Count