I was recently assigned a SSIS project for a client.
The requirements are;
Load data from 6 database tables into one excel sheet, while creating 4 new tabs for the new table data coming in. This excel sheet already has tabs for 2 tables, that's why only 4 more new tabs need to be created.
The database tables get updated on a nightly basis so the new data needs to be inserted into the excel sheet. This would also need to be automated, the client would have the updated data every morning when he opens the excel sheet.
Can someone please guide me in the right direction? I haven't used SSIS to an extent like this before.
More information can be provided if need be.