October 25, 2018 at 12:32 pm
Hi all,
I'm inquiring to see if it would be possible from SSRS to use boolean selection criteria, and when set to yes to trigger an SSIS package which would then extract data based on the end users input from a database and insert into an excel spreadsheet.
The reason for this approach is I have a report that I created in SSRS which works well. However, there is a problem when the end users need to render the report to excel. My company is currently using SSRS for SQL 2008 R2 with no plans to upgrade, which has an excel limitation of 65K rows and 256 columns. There will be instances when the end users will exceed the row limitation. The end users would prefer for the larger results(multiple months) exceeding the row limitations not to be broken out into tabs using the page break workaround in SSRS. CSV is not a good alternative since some of the formattings may be lossed and we prefer not to have the end users adjusting for the missing formats.
Ultimately, how to trigger starting the SSIS package from SSRS once I select view report in SSRS?
October 25, 2018 at 12:47 pm
You could do this, however, it seems an odd idea. How is the SSIS package deployed. Honestly, if you're on SQL Server 2008, not having SSISDB makes this harder.
On the note of no plan to upgrade; you know that 2008 is out of support, and almost entirely out of extended support, right? That opinion needs to change.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2018 at 1:04 pm
Thom A - Thursday, October 25, 2018 12:47 PMYou could do this, however, it seems an odd idea. How is the SSIS package deployed. Honestly, if you're on SQL Server 2008, not having SSISDB makes this harder.On the note of no plan to upgrade; you know that 2008 is out of support, and almost entirely out of extended support, right? That opinion needs to change.
Yes, I agree this approach is odd, but I was researching and I do think it's doable. I'm just not sure how to integrate the SSIS portion.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply