Try to use the ODBC Connector instead as explained on this forum thread. See on that thread how they handle issues with dates.
Basically, you will use an ADF pipeline to copy data from Azure SQL to an Azure Blob Storage and then using another pipeline you will copy from the Storage Account to the Teradata database