This should do it, exchange GETDATE() for the date you deriving the column from. Apply the Logic to the Hours/minutes/seconds if you need to suffix 0's to that also.

(DATEPART( "Month", GETDATE() )<10?"0"+(DT_WSTR, 250)DATEPART( "Month", GETDATE() ):(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Month", GETDATE() ))

+"/"+

(DATEPART( "Day", GETDATE() )<10?"0"+(DT_WSTR, 250)DATEPART( "Day", GETDATE() ):(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Day", GETDATE() ))

+"/"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Year", GETDATE() )

+" "+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Hour", GETDATE() )

+":"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Minute", GETDATE() )

+":"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Second", GETDATE() )