Looping RecordSet Destination in SSIS Script Task

Question

Hello

How to loop through / access values of RecordSet Destination in SSIS Script Task.

Thanks

Answer 1

Ok got this done as

        OleDbDataAdapter oleDA = new OleDbDataAdapter();
        DataTable dt = new DataTable();
        oleDA.Fill(dt, Dts.Variables["containerHeader"].Value);

once datatable is filled can do looping on it.