Excel Connection Manager failed to connect and retrieve table information error in SSIS
Could not retrieve the table information for the connection manager ‘excel connection manager’. Failed to connect to the source using the connection manager ‘Excel Connection Manager.
Two possible cause:
- Need to install access database engine 32 bit or 64 bit.
- Check package is support to 64 bit or 32 bit issue.
- Download the access database engine first for 32 bit then 64 bit and then install:
- If not fixed then, go to the SSIS package name –> Right click –> go to properties:
Check the setting in debugging tab as shown in image:
Note: In my Case, 32 bit download is working because in step two I already change to false in debugging tab.