SSIS Date in derived column as yyyy-mm-dd format
SSIS Derived Column expression variant:
(DT_STR, 4, 1252) DATEPART("yy" , GETDATE()) + "-" +
RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2) +
"-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2)
I usually use unicode:
SUBSTRING((DT_WSTR, 4)(GETDATE()), 1, 4)
(DT_WSTR,10)(DT_DBDATE)(GETDATE())