<div>
Hi<br />
<br />
This should help<br />
<a href="http://www.itcouple.com/ssis-if.aspx" rel="ugc">http://www.itcouple.com/ssis-if.aspx</a><br />
<br />
You can nest them using brackets... Let me know if you need an example (I actually need to post an example the above page with nesting).<br />
<br />
Hope that helps<br />
Emil
</div>


Hi

This should help
http://www.itcouple.com/ssis-if.aspx [http://www.itcouple.com/ssis-if.aspx]

You can nest them using brackets... Let me know if you need an example (I actually need to post an example the above page with nesting).

Hope that helps
Emil

<div>
thanks, that is much appreciated Emil,,,would the brackets just go back to back?
</div>


thanks, that is much appreciated Emil,,,would the brackets just go back to back?

<div>
I'm not sure if typed it correctly but below should give you the answer:<br />
<br />
(Field==2?1:(Field==3?1:2)<wbr />)<br />
<br />
Regards<br />
Emil
</div>


I'm not sure if typed it correctly but below should give you the answer:

(Field==2?1:(Field==3?1:2))

Regards
Emil

<div>
<div class="content wysiwyg-content">
What’s the expression language within a derived column transform to do CASE type stuff…<br />
<br />
Basically, I’m adding a column that is a retainer percent that adjusts client spend based on date so if<br />
<br />
Tape_aired &lt;&nbsp;1/31/11 then RetainerPerc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = &nbsp;.97 for that row<br />
Tape_aired between 1/31/11 and 2/15/11 then RetainerPerc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= .984 for that row<br />
Tape_aired between 2/15/11 and 3/30/11 then RetainerPerc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= .992 for that row<br />
<br />
<br />
THanks all as this site has been amazing for me...
</div>
</div>


What’s the expression language within a derived column transform to do CASE type stuff…

Basically, I’m adding a column that is a retainer percent that adjusts client spend based on date so if

Tape_aired < 1/31/11 then RetainerPerc                                                               =  .97 for that row
Tape_aired between 1/31/11 and 2/15/11 then RetainerPerc                      = .984 for that row
Tape_aired between 2/15/11 and 3/30/11 then RetainerPerc                      = .992 for that row


THanks all as this site has been amazing for me...

Case statement in SSIS expression lingo

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.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.