c# - SSIS Getting Execute Sql Task result set object -

i have execute sql task item , getting multiple rows of data stored proc.

declared variable objshipment under variable table , assigned under result set following info:

result set:    full result set result name:   0 variable name: user::objshipment 

i have written script task objshipment variable assigned readonly wondering how retrieve data within it?

the stored proc returns multiple rows id, itemid, datecreated.., how retrieve them if interested in itemid? , since returns multiple rows there more 1 itemid.

i new ssis appreciated!

so speaking use object variables within ssis package enumerator of each container.

1. create each loop container.
2. set enumerator "for each ado enumerator".
3. set source variable user::objshipment.
4. assign each column object own variable in variable mappings tab.
5. within each loop container, use variables whatever want: insert them database, lookups , audits, etc.

if going use script task, need

datatable dt = new datatable(); oledbdataadapter oleda = new oledbdataadapter(); oleda.fill(dt, dts.variables["user::objshipment"].value); 

and use dt old datatable.