I'm having an issue and I don't know if this is possible to do.
I have a simple SQL task.
SELECT Name, email FROM table_name
Using a result set, I'm trying to pass it to a variable and use it on a email task with a foreach loop but i having no luck getting this to work. If I do just one column, it works fine. My issue is multiple columns.
Thanks for the help in advance.