Get data into recordset destination, which store in SSIS variable.
Recordset is native object (not managed object) and SSIS don't come up with any component which counts the row number from in memory storage. You can read it and map to another variable only using Script Component.
Once you get the count value in variable, now it's up to you how you want to innovate the use... e.g.
