Post reply

Importing Multiple Tables to Multiple Sheets of Excel using SSIS

  • August 12, 2008 at 11:41 pm

    #154610

    Hi,

    can u plz help me out in impoting multiple tables from a SQL server database to multiple sheets in the excel using SSIS

  • August 13, 2008 at 3:29 am

    #857245

    hold the source table or entire source sql along with the destination sheet name in a table

    use an execute sql task to get this information into an ADO recordset

    use a ForEach loop to loop through the recordset

    have a dataflow task within the loop that will take the source sql (use sql command from a variable in the source connection) and send it to the desired worksheet (table name from variable)

    note, this assumes the metadata for each table is the same. it gets a lot more awkward if this is not the case.

    tom

    Life: it twists and turns like a twisty turny thing

  • August 13, 2008 at 11:19 pm

    #857830

    can u explain me more briefly as i am new to SSIS

  • August 14, 2008 at 3:16 am

    #857905

    before i do, can you confirm that the metadata for all the source tables are the same? if not, this solution won't work

    Life: it twists and turns like a twisty turny thing

  • August 15, 2008 at 2:03 am

    #858550

    Hi,

    I really need some help. I need a way of importing multiple flat files into tables using SSIS.

    Please help

    Khelelo

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply