Step 1: You can read the excel file based on below connection string in your Script Task.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"& <Your Source Path> &"';Extended Properties='Excel 12.0;HDR=" & <FirstRowIsHeader = YES> & ";IMEX=1

Step 2: Read all the Excel data's and Create any CSV format for each tab.

Step 3: Using Flat File Source load it to your destination database.