SSIS variable in case when statement
<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>