I have a Copy data Activity which pull data from Source Parquet file to Sink Azure SQL database. while doing so its throws an error of
"Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'Date_column' contains an invalid value ''.,Source=Microsoft.DataTransfer.ServiceLibrary,''Type=System.ArgumentException,Message=String was not recognized as a valid DateTime.Couldn't store <> in Date_column Column. Expected type is DateTime.,Source=System.Data,''Type=System.FormatException,Message=String was not recognized as a valid DateTime.,Source=mscorlib,'
I have run distinct command over the Date_column column below is the output -
03/27/2022 07:42:12
03/29/2022 08:05:27
03/22/2022 07:39:05
03/23/2022 08:03:05
Distinct count is 5.
I have checked the sink table. null value is allowed for date_column
I think it causing issue while convert null value in datetime. Please help me on this!