How to create multiple sheets in a single excel file?
Use the Write Excel task twice. Once for the first sheet and then on the second Write Excel Task use select Rename Sheet for the parameter, When Output File Exists. This creates a new sheet within the existing file. All other sheets within that file will remain untouched. The new sheet will have the specified sheet name, plus a numeric suffix.