While loading CSV files with dates formatted like 6/14/2007, if the Azure SQL table field allows Null values, then the date fields load, but as Null and not the date value. If the field is Not Null regardless of datatype I get an error that the field does not allow null values. I've Googled and tried adding a derived column and putting several different versions of the following code: toString(toTimestamp(<Your_Column_Name>,'MM/dd/yyyy HH:mm:ss'),'yyyy-MM-dd HH:mm:SS') but always return null values. Also after Googling I've tried changing the format in the Source Projection tab to yyyy-MM-dd and I still get the error that I can't load Null values although there are no Null values. It appears that I'm not the only one who has had this problem. Please advise.
I'm using Azure Data Factory




