Automatic data type detection

Hi experts! 
I have access to a Source that has multiple column, all of them declared as text.

it doesn't matter if there is a date, numbers etc - the source declared everything as a text.

We are talking about multiple tables with a lot of columns.

Now I would like to change this columns into the right format in the Dataflow.

Is there any automatic way to define each column?