SSIS Conditional Column Transformation
===

I am using SSIS (SQL Server 2008 R2) to transform an input CSV file into an SQL table.  Five columns in the input file (reals - e.g. 19.54271) occasionally have a bad value (strings - e.g. "NAN") that cause the package to fail.

What is the simplest way to check these 5 columns for the bad value "NAN", convert that into either a NULL value or known bad numeric (-9999), and write the corrected values into the same final SQL table?

I have the following mess going so far, and finally decided to ask if there is a simpler way...

![enter image description here][1]

My current conditional logic:  
![enter image description here][2]

My Case1 Derived Column Conversion:  
![enter image description here][3]

Note: Still not sure if I can combine the other derived columns into one instance, but since my destination can have only one input, I suspect I will need to...

TIA
  [1]: http://i.stack.imgur.com/QU5Oy.png
  [2]: http://i.stack.imgur.com/zHClt.gif
  [3]: http://i.stack.imgur.com/bfkZn.gif