OK, just to get things straight.
You are using .xls with the JET provider.
Everything works when you use the sheetname TEST, but the package fails when you use the original sheetname, right?
When you construct the query with the query designer, did you add the table manually or from the Add Table menu?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP