First no you will not need to have more than 1 package. The following steps should help you build a package for your needs and takes into account if the excel file is deleted from the expected location.
1) Create New Package
2) Add SQL Server Connection Item and define for the server in question.
3) Add Excel Connection item and set path to file.
4) Click SQL object, hold CTRL key and click Excel Object
5) On menu toolbar select Task and choose transform data task.
6) On the new task line double click for properties.
7) On the source tab which should be your SQL Server change to SQL Query and insert your query in the box.
8) Click the destination tab and a create destination dialog will appear, select the text and copy and put into notepad for safe keeping. (Note if you miss this step then after you close the dialog you can press the create button to get the dialog back).
9) Click the transformations tab and verify the transformations are as expected.
10) Add an "Execute SQL Task" which is the yellow icon with two red arrows making a circle.
11) Change Description to "Create[SheetNameForExcelHere]"
12) Set Existing Connection to Excel File connection.
13) Past Create statement we coppied into notepad into SQL statement box then press OK
14) Add another "Execute SQL Task" item
15) Change Description to "Delete[SheetNameForExcelHere]"
16) Set Existing Connection to Excel File connection.
17) Insert following "DELETE FROM [SheetNameForExcelHere]" in SQL Statement and press OK.
18) Select both Create And Delete items you created (note: Create first) then on toolbar choose Workflow "On Completion"
19) If this is the last sheet select Delete and SQL Server objects else loop thru from step 4 to create another sheet and select this Delete and the next Create object (note: Select delete object first). Then choose Workflow "On Success"
20) Now save you package and test.
21) Delete the file and test again to make sure gets regenerated.
Note: If the file exists then you will get errors for the Create items that is why we use "On Completion" for the workflow. This is ok we only worry if the Delete of those tables fail.
Hope this helps.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)