StampIT
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the link.
ASKER