It is the source data. There were some datas with dd/mm/yy and some datas were dd/mm/yyyy format. the one with yyyy comes okay after conversion but the one with only yy returns a weird set of result. Example: 18/11/07 becomes 2018/11/07

1. How do I repair the bad format that I am already receiving from the source? Must fix ALL to be yyyy in stead of yy.How can I do this?

2. I want it to become american standard, which it should be 11/18/07 and not British standard which is what I am getting now.

3. What is the code to do ALL these in a single query so that in SSIS I would save the performance?