I have table with 8 lakh records, need to export to excel file. I have tried exporting data to excel sheet 2007 (.xlsx) but data is getting imported till 65000 records, both through sql and ssis. I'm using SQL Server 2008 r2 and MS Office 2007. Appreciate your help !!
Here is what I can think of :- 1. add a row_number kind of column that would give you the serial number of any row 2. while exporting you have the option of saving the ssis package, so choose this option 3. try to modify the saved package. 4. you need to modify the query such that row_number < 65000 5. map it to sheet1 6. add another data flow and modify the query as row_number between 65000 and 65000+65000 7. map it to sheet2 This would litle bit of hands on with ssis