Wednesday, March 18, 2009

How to get row counts from Recordset variable in SSIS?

Not straight forward but not difficult,
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.