June 30, 2017 at 6:47 am
Output of the new report will be more than million records (ex : 6 million records) Could you please check how we can split data equally and deliver in excel format.
June 30, 2017 at 6:54 am
subratnayak09 - Friday, June 30, 2017 6:47 AMOutput of the new report will be more than million records (ex : 6 million records) Could you please check how we can split data equally and deliver in excel format.
This might help you.
But I would question why you would want to do this. 6 million rows of data across multiple worksheets is not an effective way of working.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 30, 2017 at 7:16 am
Phil Parkin - Friday, June 30, 2017 6:54 AMsubratnayak09 - Friday, June 30, 2017 6:47 AMOutput of the new report will be more than million records (ex : 6 million records) Could you please check how we can split data equally and deliver in excel format.This might help you.
But I would question why you would want to do this. 6 million rows of data across multiple worksheets is not an effective way of working.
I agree with Phil.....why do you need 6 million rows in excel? what are you intending to do with that amount of info?
If this for a "report" as you allude to............then my thoughts are that you really need to revise your methodology. Have you looked at SSRS?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2017 at 7:50 am
J Livingston SQL - Friday, June 30, 2017 7:16 AMPhil Parkin - Friday, June 30, 2017 6:54 AMsubratnayak09 - Friday, June 30, 2017 6:47 AMOutput of the new report will be more than million records (ex : 6 million records) Could you please check how we can split data equally and deliver in excel format.This might help you.
But I would question why you would want to do this. 6 million rows of data across multiple worksheets is not an effective way of working.I agree with Phil.....why do you need 6 million rows in excel? what are you intending to do with that amount of info?
If this for a "report" as you allude to............then my thoughts are that you really need to revise your methodology. Have you looked at SSRS?
Yes, We can load to multiple tabs. But can we load multiple tab in parallel or not ?
June 30, 2017 at 8:25 am
subratnayak09 - Friday, June 30, 2017 7:50 AMJ Livingston SQL - Friday, June 30, 2017 7:16 AMPhil Parkin - Friday, June 30, 2017 6:54 AMsubratnayak09 - Friday, June 30, 2017 6:47 AMOutput of the new report will be more than million records (ex : 6 million records) Could you please check how we can split data equally and deliver in excel format.This might help you.
But I would question why you would want to do this. 6 million rows of data across multiple worksheets is not an effective way of working.I agree with Phil.....why do you need 6 million rows in excel? what are you intending to do with that amount of info?
If this for a "report" as you allude to............then my thoughts are that you really need to revise your methodology. Have you looked at SSRS?Yes, We can load to multiple tabs. But can we load multiple tab in parallel or not ?
I don't think so. I've tried reading from multiple tabs in parallel in the past and even that fails.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 30, 2017 at 10:32 am
I assume that you won't use the 6 million rows individually. How about setting a stored procedure as the source of a pivot table in Excel?
There's no way that you can handle 6 million rows individually in Excel, but you can manage them if they're grouped.
July 4, 2017 at 2:23 am
Luis Cazares - Friday, June 30, 2017 10:32 AMI assume that you won't use the 6 million rows individually. How about setting a stored procedure as the source of a pivot table in Excel?
There's no way that you can handle 6 million rows individually in Excel, but you can manage them if they're grouped.
The Requirement As below . Please suggest in detailed steps.
- Table contains data in millions.
- In SSIS package create a variable which accepts number of rows, Based on this variable value excel file should be generated and loaded.
- The above step should repeat until reading all the data from table.
- Create multiple files (Not multiple sheets in same file)
- Name of excel file should be dynamic (Like Excel_Report_1, Excel_Report_2….)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply