Sunday, February 19, 2012

Counting rows from Flat File Source

Hello,

Is there a way (perhaps a property) to capture the number of rows selected from a Flat File Data Flow Source without having to develop a script to loop through the rows and count them?

Thanks a lot,

Grace

Yep. Use the ROWCOUNT component.

Row Count Transformation

(http://wiki.sqlis.com/default.aspx/SQLISWiki/Row%20Count%20Transformation.html)

-Jamie

No comments:

Post a Comment