With SSIS, I need to convert the [Birthday] column, which is DateTime at the moment to “DATE” format.
I used a Derived column and chose the column [Birthday] from SQL server with the format below:
1952-09-25 00:00:00.000

But I couldn’t convert it with Derived Column expression to Date.
I need to see the format as DD.MM.YYYY
Can anyone help me please with the expression?
Thanks