title: SSIS Result set, Foreachloop and Variable
body: <p>I'm having an issue and I don't know if this is possible to do.</p>
  
  <p>I have a simple SQL task.</p>
  
  <p><code>SELECT Name, email FROM table_name</code></p>
  
  <p>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.</p>
  
  <p>Thanks for the help in advance. </p>