I have solved this now to the extent where I have achieved the first two parts but not the third. No need to respond. Thanks.

Hi skcadavre

I've just had a quick look. In the conditional split you are having to hardcode the condition, i.e. Dept = 'BI'. So I would be manually working out the...

Hi skcadavre

Thank you, I shall look these links up.

Hi steveb

I am not re-write the query using an alias for the column as each week when the package is run there will be a different date present in that...

Hi all

Thank you for your replies, and a big THANKS to 'Mr Quilz' for the detailed response.

I used some methods of that reply but mostly used a different method as...

Nope. Only the database has been created. As I do not know how many worksheets there will be when the SSIS package is run each week I would like to...

Hi Aquila

Thanks for your reply.

If I saw the code I would know whether is it what I'm looking for or if I could work with it.

My requirements would be to...

Thanks for your replies KevinGurney and brian118

No, the Excel workbook will not have the same number of worksheets each time. The number of worksheets mary vary.

Therefore, I cannot just set...