Good Day
I have a problem where I have an Excel .xlsx file in the Data Lake, the size of the file is 48MB.
I am trying to copy this file into an Azure SQL DB.
This task works for many other smaller files but when it gets to this file it just hangs without copying any rows across.
I double checked, all of the column names are correct and I am inserting into a staging table with only varchar columns so it cant fail on a data type issue.
I let the task run for over 16 hours without any progress, the throughput keeps on dropping to the point where it was being measured in Bytes.
Are there any know issues with excel files in the platform or has anyone experienced this problem before?
Thanks in advance.