SSIS Data Flow Record Count

Question

I thought I used to see a Data Flow Record Count when my SSIS Package was running. The Data Flow has...

• OLE DB Source which executes a SQL Server Stored Procedure
• Row Count used to capture the Row Count to a Variable
• Flat File Destination

My Microsoft Visual Studio Color Theme is Light but I do not seem to see any record count as this is running in Microsoft Visual Studio. That would GREATLY help me to determine the progress of this lllooonnnggg running SSIS Package.

Answer 1

Hi @Bobby P ,

1.We can add Data Viewer which can display the number of rows and the data buffer by buffer as data moves between two data flow components.

2.The Row Count transformation stores the row count value in the variable only after the last row has passed through the transformation. Therefore, the value of the variable is not updated in time to use the updated value in the data flow that contains the Row Count transformation.
If we use Row Count Transformation in Data Flow Task, we can use the following ways to read the value of variable by editing Breakpoints (OnPostExecute event) or use the value of variable in another task.

Please refer to the following pictures:

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Add a Data Viewer to the data flow paths: https://learn.microsoft.com/en-us/sql/integration-services/troubleshooting/debugging-data-flow?view=sql-server-ver15#data-viewers