Foreach loop doesn't loop

I have a foreach loop that is supposed to loop through a recordset, however it doesn't loop. It just repeats the same row, row after row.

I would like to look into the recordset variable but I can't because it is a COM object and the ADODB namespace is not available in the script task.

Any solution to this? anyone experienced anything similar

I have narrowed this down to enabling of checkpoint logging.

I have 3 loops inside each other. This is the top level loop that doesn't get past the 2nd row in the recordset.

Not got a simple repro yet.