SSIS||Steps to load Multiple Excel Files into SQL tables

Steps to load Multiple Excel Files in SSIS:

1. Create Two variables (Names of the variables as per your interest)
FilePath with Value
FileName with No Value (Make sure you didn't have even '0' as well)

2. Create Two Connections (Excel & OLEDB)

3. ForEachLoop Container
Select ForEach File Enumerator
Write Expression code to Directory Property for variable (FilePath)
Variable Mapping FileName (0)
Opt Name and Extention and *.xlsx file extention

4. Drag Data Flow Task inside ForEachLoop Container
Configure Excel Source and OLEDB
Select Sheet1$ during Excel configuration
Select Table name during OLEDB configuration

5. Goto Properties of Excel Connection Manager and write expression to ExcelFullPath property as @FilePath + @FileName

6. Change the delay validation property to TRUE

7. RUN the package