Integration Services :: Reading Recordset Multiple Times Gives 0 Rows

I have an EXECUTE SQL Task, which gets a result-set from SQLServer using OLEDB Connection.

The result set is mapped to an object variable , say @[User::FilePath]

There are 33 row is the above resultset.

Then, I have a For-each loop, inside which, I have a Script task .

I am trying to put the above @[User::FilePath] recordset into a DataTable using DataAdapter.Fill() function. I perform some read operations to its rows.

The problem is , in the First Iteration of For-Each-Loop, the number of rows in data-table shows 33.

But from the Next Iteration, it comes out to be 0. (ZERO!!)

This causes my package to fail.