I have an issue trying to import data from Excel file (Source.xlsx) using dtsx package.
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
Excel Connection Manager
After that I added Excel Source in the Data Flow Task, but I couldn't choose name of the Excel sheet with the error:
Data Flow Task: Data Flow Task: A connection manager has not been assigned to the Excel Source.Connections[OleDbConnection]
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.
It would be so kind to get any suggestions and tips to solve this problem.
Thanks in advance.