January 17, 2020 at 4:47 am
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?
January 17, 2020 at 11:37 am
Who or what is the source of the excel files? Could it be where the source is has exported them as 2013 office format or above? If it's a 3rd party then your going to have to re-work the connection strings for the updated providers.
Office 2010 goes out of support this year, highly recommend you start the upgrade process and sharpish to ensure everything is tested and signed off, otherwise your going to leave yourselves open to potential attack surfaces by using out dated software.
January 17, 2020 at 11:56 am
Can you confirm that all of the files are in .XLS format?
Probably unrelated, but I saw this error when I tried to open a .XLSB file using a (ACE) .XLSX connection string.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply