I haven't published a nugget for a while but today a guy called Antonio was asking me how one might output the captured rowcount in a file so i thought I'd put something together that demonstrated it.
Its very simple, although you will need two data-flows. One to capture the rowcount (using a rowcount component), and another to output that captured value.
Here's the first data-flow that contains the rowcount component
and the second that outputs the value:
The trick is being able to put the captured value into the data-flow and you do that using the Derived Column component. Within the Derived Column Component your expression simply has to contain the name of the variable into which you earlier captured the rowcount.
Following your putting the value into the data pipeline you simply output it using a flat file destination adapter.
That really is all there is to it. Hope you find it useful Antonio!
You can download the demo package from here: http://blogs.conchango.com/jamiethomson/attachment/6164.ashx. One caveat - it runs against the sample AdventureWorks database (its got to count some rows from somewhere right?) so you will need to have that installed. The package will look for this database on the localhost server.
-Jamie