title: SSIS Excel Connection Manager failed to Connect to the Source
body: <p>I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server.</p>
  
  <p>The problem happens when trying to design the package.  I have added an excel connection and pointed it at the Excel file on a local disk (the same file I have already successfully imported using the import wizard). When I add an Excel Source to the DataFlow and specify the excel connection, when I go to the Name Of the Excel Sheet Drop down I just see "No tables or views can be loaded" and get the following error.</p>
  
  <p>"Could not retrieve the table information for the connection manager.
  Failed to connect to the source using the connection manager ..."</p>
  
  <p>I can't find this error logged anywhere and i don't know why it is failing. The directory is shared to Authenticated users and the file is not in use.</p>
  
  <p>Any ideas how to debug this error? I understand there can be issues running this in 64 bit mode, but does that apply to development?</p>
  
  <p>I should add that it is an excel 2007 file .XLSX and the connection is set to Excel 2007.</p>
  
  <p>2019-11-08 The answer by GavB841 below looks promising, if anyone tries it and it works please let me know. (I am no longer working in this area.)</p>