title: SSIS set result set from data flow to variable
body: <p>Before I give myself some sort of stress related heart attack. </p>
  
  <p>Would anyone know how to complete the seemingly simply task of setting the result set of one data flow task (the result will be either a 0 or 1) and assigning that value to a variable.</p>
  
  <p>I've created the variable ok. </p>
  
  <p>The result set comes from an XML file with multiple elements. The flag (0 or 1) is the result from one of those elements, so I also need to know how to get the result set to be just that flag. </p>
  
  <p>If anyone could help I would really really appreciate it.</p>
  
  <p>Update : I eventually read the result (0,1) back to SQL Server into a flag table. Then used a Execute SQL script to read it back from SQL Server and to a variable. Not sure if this is the best way to have done it but it seems to have done the trick.</p>