Insert Data From More Than One Excel Sheet Of One File Into Table Using Ssis?

i have one excel file that contains a1 to a5 rows with values now a6= sum(a1:a5) I want a6 value to be inserted into database using ssis package How can i do mapping ;(

Solution 1:

If you always want to ignore the first 5 rows and take the value in the 6th, use the SQL Server Destination component and set the first row and last row to insert as explained by Jiqin Ma Import single cell