My execute sql task returns a "full result set" which I store in an Object objResults. I want a simple way to get the number of rows in objResults. How do I do it ? I want to use c# code to get that number.
I could load the whole objResults into a DataTable and get the numberOfRows with myDataTable.Rows.Count;, but that approach is obviously inefficient.
A bit of information about my code - An execute sql task simply puts all the records into a recordset, ADO i think. Then a script task reads it and loads it into a database. There is no data flow at all. All control flow tasks only - so row count transform will not work. Any simple C# code ?