Forum Discussion
Error with DATETIME2 in Copy Activity (CSV to SQL Data Warehouse)
Hey everyone, I'm running into an issue in Microsoft Fabric's Copy Activity while trying to copy a CSV file into my SQL Data Warehouse. I'm adding a new column with a datetime2 value before the copy...
according to documentation datetime2 in warehouses supports up to 6 digits fraction of seconds.
looking to your code you're using 7 digits.
I unfortunately get the same error after changing the digits