How to fix 'Couldn't interpret '0000-07-01' as a valid DateTime' Error in copy activity - synapse analytics pipeline

Hello,
Synapse analytics-copy data activity returning below error. But in my case many rows are having "0000-07-01" date in the DB table column.
I have tried to change the datatype then to debug. But failed to copy.
And then I tried copy activity with single table and bulk table. but there is no luck.
Can any one help for this?

"errorCode": "2200", "message": "Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path: 'usprodannex1/synapse/workspaces/synapse-preprod-annexcloud-01/warehouse/AllTables/user.parquet'.,Source=Microsoft.DataTransfer.Common,''Type=System.FormatException,Message=Couldn't interpret '0000-07-01' as a valid DateTime,Source=MySqlConnector,''Type=System.ArgumentOutOfRangeException,Message=Year, Month, and Day parameters describe an un-representable DateTime.,Source=mscorlib,'", "failureType": "UserError", "target": "Testcopy Data", "details": [] }