How to use RowCount in SSIS

RowCount in SSIS 

 
Step 1: Create variable to store the row count value.
 
RowCount in SSIS
 
RowCount in SSIS
 
Step 2: Go to DataFlowTask-> Drag & Drop the RowCount component and connect the input.
 
RowCount in SSIS 
 
Step 3: Select Female RowCount component -> Edit.
 
RowCount in SSIS 
 
Step 4: Do the step3 for the MaleRowCount variable also.
 
Step 5: Add a script task in the DataFlowDesigner pane and connect it.
 
RowCount in SSIS 
 
Step 6: Right Click ->Script Task-> Click Edit-> Click -> ReadOnly Varibles option
 
RowCount in SSIS 
 
RowCount in SSIS 

Step 7: Click Edit Script and use the below code in the Main function.
 
RowCount in SSIS 
 
Step 8: Execute the package and you can get the result.
 
RowCount in SSIS 


Similar Articles