Reader Level:
Articles

How to use RowCount in SSIS

By Muralidharan Deenathayalan on May 19, 2011
Here you will see How to use RowCount in SSIS.
  • 0
  • 0
  • 37613
Download Files:
 

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

COMMENT USING

Trending up