Excel Source Task in DATA FLOW not working in SSIS package

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:

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


  1. Download the access database engine first for 32 bit then 64 bit and then install:
  1. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.