Excel Connection Manager failed to connect and retrieve table information error in SSIS

Error:

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.

Cause
Two possible cause:

1. Need to install access database engine 32 bit or 64 bit.
2. Check package is support to 64 bit or 32 bit issue.

Solution:

1. Download the access database engine first for 32 bit then 64 bit and then install:
   https://www.microsoft.com/en-us/download/details.aspx?id=13255

2. 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.