I have a SSIS package that reads from a flat file source. The target file is also a flat file.
I want to count the rows that are written in the target file.
How can this be done?
You can use RowCount for that. Below links may help you
http://www.daveturpin.com/2009/10/writing-query-row-count-to-flat-file-in-ssis-part-i/