The Excel file may say it’s locked if the user who shared it with you is currently editing the document. It can also be because the Office app running in the background has already opened the file.

While this is a good thing from a performance standpoint, it will lead to trouble if they try to read an Excel file. The drivers that connect to Excel are 32-bit and when your SSIS package runs ...