title: The type of the value being assigned to variable "User::de_sters" differs from the current variable type
body: <p>I have a variable <code>de_sters</code>, a string type variable, as it is defined in my SSIS package, its scope is SSIS package, which I need to <code>fill</code> with the value of several lines from one table, usig an <code>Execute Sql Task</code> package.</p>
  
  <p>Bottom line is that I have an "Execute Sql Task" package, in proprieties ->"Sql Statement" I have wrote:</p>
  
  <pre><code>declare @s varchar(max) = '' 
  select @s =  case when @s &lt;&gt; '' 
                    then  @s + ',''' + employer_name + '''' 
                    else   @s + '''' + employer_name+ ''''
                    end 
  from employers
  select @s as Result
  </code></pre>
  
  <p>Then, at <code>Result Set</code> I selected <code>Single Row</code> (first I have ran my select and I saw that it returns only one line). Then on tab <code>Result Set</code> (left side) I  wrote in <code>Result Name</code> field <code>Result</code> (the alias from my previous sql statement) and in filed <code>Variable Name</code> I wrote <code>User::de_sters</code>.</p>
  
  <p>But when I run sql task it gives me</p>
  
  <pre><code>The type of the value being assigned to variable "User::de_sters"
  differs from the current variable type" error.
  </code></pre>
  
  <p>Any help, or hints?</p>