• Here's another option.

    REPLACE((DT_WSTR, 10)(DT_DBDATE)GETDATE(),"-","")