I hope your are doing well.
I've been breaking my head since yesterday. I hope you can help me.
I have an error on the production server. SSIS can no longer connect to an Excel file. I have an error "external table is not in the expected format". I work with Excel 2010 32 bits and SSIS 2017 64 bits
In the project, I have a dozen Excel source files (2003-2007 excel files) but there are only 2 files that are in error. -> What makes me crazy is that when I open the file, SSIS can connect to the file. I close the file and the connection goes wrong -> When I save the file in Excel 2010 version SSIS happens to connect.
Do you have an idea to help me?