I am loading data from Salesforce to a Azure SQL via a simple Copy data activity. I have a precopy script to drop the destination table and reload the table from Salesforce. But i keep getting the below error.
ErrorCode=TypeConversionNotSupportedDataTypes,Exception occurred when converting value '' for column name 'Rep_Call_time__C' from type 'TimeSpan' (precision:12, scale:3) to type 'DateTime' (precision:23, scale:3)
Since i am dropping and recreeating the table, how can I update the datatype of the destination table ? Also to what should it be modified to?