Step 1: Create variable to store the row count value.
![RowSSIS1.gif]()
![RowSSIS2.gif]()
Step 2: Go to DataFlowTask-> Drag & Drop the RowCount component and
connect the input.
![RowSSIS3.gif]()
Step 3: Select Female RowCount component -> Edit.
![RowSSIS4.gif]()
Step 4: Do the step3 for the MaleRowCount variable also.
Step 5: Add a script task in the DataFlowDesigner pane and connect it.
![RowSSIS5.gif]()
Step 6: Right Click ->Script Task-> Click Edit-> Click -> ReadOnly
Varibles option
![RowSSIS6.gif]()
![RowSSIS7.gif]()
Step 7: Click Edit Script and use the below code in the Main function.
![RowSSIS8.gif]()
Step 8: Execute the package and you can get the result.
![RowSSIS9.gif]()