• 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!