title: Unable to Connect to Excel via SSIS
body: <p>Excel file is not being recognized by SSIS.</p>
  
  <p><strong>Error :</strong></p>
  
  <blockquote>
    <p>Could not retrieve table information from connection manager "Excel Connection Manager<br>
    Failed to connect to the source using the connection manager 'Excel Connection Manager'</p>
  </blockquote>
  
  <p>I have tried installing 32-bit of redistributable which resolved this error but when I run this outside using SQL stored procedure it is failing, which is in turn resolved if i install 64 of redistributable but this is failing in SSIS,</p>
  
  <p>Hence, I need 32-bit to run in SP, and 64-bit to run in SSIS but I cannot install both at the same time. Is there any solution to this issue.</p>