Excel Source Task in DATA FLOW not working in SSIS package

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
  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 )

Twitter picture

You are commenting using your Twitter 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.