title: SSIS error: Connection manager has not been assigned to the Excel
body: <p>I have an issue trying to import data from Excel file (Source.xlsx) using dtsx package.</p>
  
  <p><br>The system is Windows Server 2019 Standard and there is no MS Office installation on this server, so I installed MDAC 2010 32 bit and added Excel Connection Manager in the Connection Manager
  <a href="https://i.stack.imgur.com/xB3yy.jpg" rel="nofollow noreferrer">Excel Connection Manager</a>
  <br>After that I added Excel Source in the Data Flow Task, but I couldn't choose name of the Excel sheet with the error:</p>
  
  <pre><code>Data Flow Task: Data Flow Task: A connection manager has not been assigned to the Excel Source.Connections[OleDbConnection]
  </code></pre>
  
  <p><br>It's the first time when using MDAC doesn't help in such case. I was looking for any solution and I can assume that only solution is to install MDAC 2010 32bit, but unfortunately it does't help in my case.</p>
  
  <p><br>It would be so kind to get any suggestions and tips to solve this problem. </p>
  
  <p><br>Thanks in advance.</p>