I'm building a package to import several Excel files on my SQL Server. The server does not have Excel installed but I have installed bot the of the ACE drivers.
In the ForEach Loop collection - I set the file to .xlsx but after I saev the package, it reverts back to .txt
The files in my input folder variable ARE .xlsx. I don't know what's going on but it's very frustrating, I'm stuck until I get over this hurdle.