SSIS OLE DB Source changes how Date values are returned

I am creating an SSIS package which is reading from a SQL Server database. The data returned needs to be imported into an ERP system.

The SQL statement I use in the OLE DB Source returns the Date values formatted this way: 01/01/1900. The dates need to be formatted this way in order for the ERP import to work. So this is working fine when the SQL statement is run in SQL Management Studio.

However when I execute the statement as part of the task in the SSIS package, the Date values are returned formatted like this: 1900-01-01. This does not work for my ERP import.

The only way I found which let me keep the format I need (01/01/1900) was to return the Date columns as Strings enclosed in double quotes ("01/01/1900").

Then I added a Derived Column task to remove the double quotes using this expression: REPLACE(Col9,"\"","")