Nested conditional operators are described quite well in the following url by "SQL Chick": http://www.sqlchick.com/entries/2011/6/8/nested-conditional-operators-in-an-ssis-derived-column.html