SSIS Expression Convert From IntDate to String

In a SSIS Expression how do you get from 20160101 to 01/01/2016?

Use this command in Derived Column Editor and replace the field that you’re intending to convert.

SUBSTRING((DT_WSTR,8)[TimePeriod],5,2) + “/” + SUBSTRING((DT_WSTR,8)[TimePeriod],7,2) + “/” + SUBSTRING((DT_WSTR,8)[TimePeriod],1,4)

I found several incomplete examples that didn’t include the (DT_WSTR,8) conversions of the int field. This is just to help people who also need int to Date in SSIS.

Cheers.