Excel files are bulk imported into SQL Server database (using the foreach container)

Specific steps such as:
1, first drag a foreach control in the SSIS Toolbox, and select the corresponding folder, matching the corresponding file, as follows

2. Create variables to receive

3. Drag into a data Flow task, and then drag it into an Excel source and OLE DB Destination, respectively, with the following settings

4. Edit the Excel Connection Manager, here will use a foreach variable to replace the Excel file that you just selected, the Connection manager's properties to set the mapping method of the variable, expressions attribute Edit list, left select Excelfilepath, This is the property of the Connection Manager, we will use the variable instead, then click on the expression's property Edit button, drag the variable user variable in the list to the expression box below, this is the error of SSIS, and give a warning, open the Properties window of foreach, Setting DelayValidation to True is possible.

Excel files are bulk imported into SQL Server database (using the foreach container)