title: SSIS variable in case when statement
body: <p>It's possible to use SSIS variable in case when statement in Data Flow?</p>
  
  <p>I have to implement something like:</p>
  
  <pre><code>select
  ...
  case when Data &gt;= ? then NULL else Data end DataName,
  ...
  from ...
  where filter = ?
  </code></pre>
  
  <p>where "?" is iterator, which I get from Foreach Loop (over 100 iteration). Whole query have over than 4000 chars.</p>
  
  <p>I use SQL Server 2008R2. I have also to load this query to different server.</p>