Row Count Transformation
The Row Count transformation counts rows as they pass through a data flow and stores the final count in a variable.
A SQL Server 2005 Integration Services (SSIS) package can use row counts to update the variables used in scripts, expressions, and property expressions. For example, the variable that stores the row count can update the message text in an e-mail message to include the number of rows.
The variable that the Row Count transformation uses must already exist, and it must be in the scope of the Data Flow task to which the data flow with the Row Count transformation belongs.
This transformation has one input and one output. It does not support an error output.
Configuring the Row Count Transformation
You can set properties through SSIS Designer or programmatically.
The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:
For more information about how to set the properties, click one of the following topics:
- How to: Set the Properties of a Data Flow Component in the Properties Window
- How to: Set the Properties of a Data Flow Component Using the Advanced Editor
See Also
Concepts
Integration Services Variables
Creating Package Data Flow
Integration Services Transformations