In a container there are 5 files are present.With the same column name.But the order of the column name are different among all the 5 files.
When i run query in MS Sql server i am getting the error :
Msg 15813, Level 16, State 1, Line 1
Error handling external file: 'Max errors count reached.'. File/External table name: 'https://storagename.blob.core.windows.net/staging-zone/FolderName/Filename*.csv'.
Please advise how i can solve this issue