SSIS Excel Connection manager validation is taking forever. The same package works when running Visual Studio in administrator mode. The Excel file I am reading is from a local folder. I set the Security of both Package and project to "DontSaveSensitive"
After spending almost the whole day, I found out that the TargetServerVersion did not match the target SQL server. Fixing that resolves the issue.