SSIS convert object variable to string in expression builder
<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>