September 7, 2016 at 6:49 am
Hi,
We are export a large record set SSRS report (multiple years). It is reasonably fast pulling the data - the issue is in the final stage the excel export rendering.
We have tried most of the methods online - nothing seem to be bale to export to excel rapidly.
We cannot use CSV.
We can use Sharepoint - in case there is some option there we don't know about.
Are there any third party tools that can handle a large record set export quickly?
September 7, 2016 at 6:57 am
Why not use SSIS to write to the Excel file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 7, 2016 at 7:09 am
Koen Verbeeck (9/7/2016)
Why not use SSIS to write to the Excel file?
Wish we could. End users need to be able to choose parameters.
It would be ideal if the end user could choose report parameters and pass them to ssis then ssis could export out to excel. Is that possible?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply