Link to home
Start Free TrialLog in
Avatar of StampIT
StampITFlag for United States of America

asked on

Extracting the contents of a full result set from a Execute SQL Task in SSIS

I have successfully used an Execute SQL task to insert the column values of a query into variables when employing a single row result. I would like to do something similar with a full result set. All I have been able to do is populate an object variable. The value of this variable = System._ComObject. I understand that this can be used in other SSIS components like a For Each Loop container. What is the process ? Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Vikas Garg
Vikas Garg
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of StampIT

ASKER

I am in the process of trying this out. Thanks.
Avatar of StampIT

ASKER

Thanks for the link.