Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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:

      alt text

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

like image 626
theog Avatar asked Dec 13 '22 21:12

theog


1 Answers

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.

like image 164
Cade Roux Avatar answered Dec 28 '22 08:12

Cade Roux