In the ETIS SSIS conversion, I am trying to load a specific .xls file. I have several identical files with similar circuits, and they all work correctly. However, this single file causes the error "External table does not match the expected format." This is what I tried:
- I already changed the connection string from Jet OLEDB to ACE OLEDB, with no result.
- I changed the connection type from Excel 97-2003 to 2007, with no result.
- Connection Manager uses a variable, so I tried to create another Connection Manager that directly loads the file. No result.
- I use a SQL query to read from a file, so I tried reading the sheets that the file has. They do not load.
- I tried "Save As ..." and used Excel 97-2003.
- I tried to save the file.
- I tried to restore the original file.
- I checked the sheets that the file has and compared them to the one it downloads. At least both have the same sheets.
What is weirder is that the file loads correctly if I keep it open in Excel when it loads in SSIS. As additional information:
- The file has macros, but other files do the same.
- My computer runs a 32-bit architecture.
- I am using Visual Studio 2010 + SQL Server 2012.
What else could cause this error?
EDIT: Now I tried to configure the ADO.NET source and OLEDB source to open the .xls file. ADO.NET cannot "retrieve information from columns", and OLEDB closes the connection. Maybe there is a way to find out when the excel file will work?
- : , , Google . SSIS, .