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.