This short writing shows you the right approach to use Row Count Component in SSIS. This writing assume you know what is Row Count and how to use the Row Count despite the right or wrong way. Just be reminded you need a SSIS variable (only int32 type) in order to use Row Count.

The below data flow will not work for Row Count. Row Count will only be updated when the data flow completed. This is my finding of SSIS packages.

To illustrate this I created a simple flow with a Script Task.

Below is what in the Data Flow Task.

This is the code you need to inside into Script Task.What I did was, I was writing the Row Count value into a text file.publicvoid Main(){Dts.TaskResult = (int)ScriptResults.Success;