Thanks for looking Phil!
pretty sure the office is using vs2008 for ssis and ssrs, so that's probably 2008; i couldn't seem to find a 2008 SSIS forum.
Ironically, i had done something similar in .net already; and i'm in the middle of building an variation this morning with a copy-paste GUI ;
the code is simple, stick a query's data in a datatable, and then i created a variety of export options (excel,html, pdf, etc)
the multi page worksheet was a new wrinkle on an old example.
the issue really is i wanted to help someone else who only used bids as far as ssis/ssrs, and needs a working model of something in ssis so he can accomplish his task of hybrid excel sheets like this.
the conversation started as how can i make this report in SSRS, and that kind of shaped the original direction.
i found an example here that i'll check out
http://www.codeproject.com/Articles/301542/Creating-Excel-File-and-ExcelSheets-dynamically-fr
that project gets all the tables from sysobjects and creates worksheets of their data.i'd think i can modify it enough to do the same thing i' did in .net.
Lowell