Insert data from more than one excel sheet from one file into a table using SSIS?

Question

I have one excel file containing a from 1 to a5 lines with values ​​now a6= sum(a1:a5)

I want the a6 value to be inserted into the database using ssis package

How can I match (

Answer 1

If you always want to ignore the first 5 rows and accept the value in the 6th, use the Destination SQL Server component and set the first row and last row to insert, as explained by Jiqin Ma Importing individual cells