• hi,

    please tell me how to export sql server single table into multiple excel sheets in single Excel file using SSIS package.(ex-have region column in source table and have to export data in destination as different sheets name like region1,region2 in same excel file.based on region column value it has to write the value in region1 and region2 and so on ..) also for each run by everyday new data should be inserted and old data has to be truncated.