Convert date in string to datetime2 SQL type in Data Factory

Question

I used the derived column to convert format dd-MM-yyyy HH:mm:ss to datetime format yyyy-MM-dd HH:mm:SS

toString(toTimestamp(Fecha_dep,'dd-MM-yyyy HH:mm:ss'),'yyyy-MM-dd HH:mm:SS')

the result is good and now the format is the required, no I need to import this value to SQL
My pipeline copies from SFTP to Blob as text then from blob to blob as parquet and finally from blob to SQL

the conversion is done in derived column

finally the result should be taken by last copy activity to SQL

Here the datetime format should recognize the format and idenitify it

but i get this warning in the mapping

and this error when the pipeline runs

i also tried to have timestamp as final data format before exporting to SQL but the result is the same

is there an specific format required for parquet ?¿

Answer 1

I just installed this software to read parquet files, i dont know if it really works but it seems the conversion is not applied. according to the data preview should be OK