I need to run a query on a database.
It will return 2 columns and many lines.
I would like to turn this table as such into a foreach loop.
Here, for each row, assign both bivariate column values each time.
I can do it with a column using Execute Sql Task with Full Result Set.
If I try two columns, the second column does not appear to be assigned to the pending variable.
This is possible?