Is there a decent technique for SSIS Derived Column date formatting?

Question

I just had to write the most redonkulous expression in an SSIS Derived Column to get dates formatted like "01-JAN-2010".  It lookes like this:

      

There's got to be a better way... isn't there?

Answer 1

Consider using a script component and then Row.stringcol = Row.datecol.ToString("dd-MMM-yyyy") to populate a new string column in the data flow.