You'll need to execute a SQL task for each tab using an EXCEL connection manager pointing to the output spreadsheet. The SQL task contains the DDL to do the CREATE TABLE used to generate the Excel tab. Then complete a separate data flow to populate each tab. Wire them up sequentially and you'll generate a multi-tab spreadsheet.