I think I faced this situation before and what I did (maybe is not the smart way) is to parse the strings using an expression in a Derived Column component. You will need a couple of tricks like the RIGHT function to force a leading zero for the month and days if they have only one digit, but at the end it is not so difficult.

Let me know if you have further questions.

Kind Regards.