<div>
Try this<br />
<br />
case when isnull(Amt,1) then<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case Amt when 0.01 &gt;&nbsp;1,000 then 2<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else Amt end<br />
else Amt end
</div>


Try this

case when isnull(Amt,1) then
      case Amt when 0.01 > 1,000 then 2
      else Amt end
else Amt end

<div>
Please note: i need in use in derive column transformation in SSIS, you sample is for t-sql
</div>


Please note: i need in use in derive column transformation in SSIS, you sample is for t-sql

<div>
thanks for that, sorry i am not familiar with Ternary operator, kindly post some samples if possible, and also ca ternary operator be nested?
</div>


thanks for that, sorry i am not familiar with Ternary operator, kindly post some samples if possible, and also ca ternary operator be nested?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to add large case statemnt in a derive column &nbsp;tranformation in SSIS. The query is similar to below however I need to nested more than the sample below. The simple query like below is throwing an error., i'm not sure what wrong with that syntax. I would appreciate if I can get samples nested query for SSIS derive column transformation.<br />
<br />
ISNULL(amt) ? &quot;1&quot;:Amt &amp;&amp;&nbsp;iif(Amt)==&quot;$0.01 &gt;&nbsp;$1,000&quot; ? &quot;2&quot;:Amt<br />
<br />
Thanks
</div>
</div>


Hi,

I need to add large case statemnt in a derive column  tranformation in SSIS. The query is similar to below however I need to nested more than the sample below. The simple query like below is throwing an error., i'm not sure what wrong with that syntax. I would appreciate if I can get samples nested query for SSIS derive column transformation.

ISNULL(amt) ? "1":Amt && iif(Amt)=="$0.01 > $1,000" ? "2":Amt

Thanks

use of nested statment (CASE or if...else...) in derive column transfromation in SSIS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.