I am trying to load Excel(2017) data into SQL Server using SSIS. When i try to load directly , it is throwing error.
Error : External Table is not in the Expected Format
But when i open and saving that same excel file as .xlsx format it loads without error.
How to solve this issue?