Post reply

SSIS - Copy to multiple XLS based on Parameter table

  • August 19, 2008 at 12:51 am

    #154633

    I have two tables, Parameter table and details table. parameter table has list of units and details tables contains multiple rows for each unit.

    I have to create Unit wise excel from my details tables. how can i do this using SSIS. How to loop the above two tables to generate excel unitwise.

    Thanks in advance.

    Vijayraj.

  • August 19, 2008 at 1:23 am

    #859812

    Using a data flow and a EXCEL source, import the two tables. Use a merge join to join the two flows into one.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 19, 2008 at 2:38 am

    #859843

    I need to get the unitwise output into SEPARATE EXCEL FILES with file name as unit name. Hence, SSIS should generate multiple excel files as per the parameter table units.

Viewing 3 posts - 1 through 2 (of 2 total)

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