title: SSIS convert object variable to string in expression builder
body: <p>I have a query in my ssis package that uses xml path to return a single row of semi colon separated values in a execute sql task. I have a user var called email_list that is then set to the ResultSet as a Single row. But when I run it, I get an error: </p>
  
  <blockquote>
    <p>The value type (___ComObject) can only be converted to variables of type object</p>
  </blockquote>
  
  <p>I realize that the variable email_list has to be set to type Object, but if I do that, and then try to use that in the ToLine field in expression builder of email task, the expression doesn't evaluate and throws an error. </p>
  
  <p>I've seen articles on here that give a script task solution but I don't want any scripts - how can this be accomplished in the expression builder itself by converting/casting the object to string?</p>
  
  <p>If it can't be done in the expression builder, what is the workaround?</p>
  
  <p>My query in the execute sql task is:</p>
  
  <pre><code>SELECT STUFF((SELECT ';' + email 
          FROM booklist..books
          FOR XML PATH('')) ,1,1,'') AS email_address
  </code></pre>