March 1, 2018 at 1:50 pm
I've read a lot of forum posts and a few blogs before resorting to creating this post. Nothing I've come across so far relates exactly to what I'm trying to do. If the solution is documented somewhere, I'm not doing the right search.
I have a script that needs to run 87 times with 87 different parameters. The result each time it runs needs to produce an Excel file totaling 87 Excel files when it's completed. I'd really prefer not to have to create 87 different SSRS reports. As stated in the subject, we're using the Standard version so we don't have the built in capability of data driven subscriptions that the Enterprise version offers.
The ideal scenario (for me) would be that each of the 87 files are emailed (separately) to a person in our company with a customized Subject line related to the 87 chapters we have. This employee will setup Outlook rules to forward them on to 87 groups. She'll have to do this based on what is in the subject line which is why I've got to be able to customize each subject line. I'd send these reports directly to who they need to go to but the email addresses will change yearly and I'd prefer not to maintain a list like that so our employee said that she would maintain the list using Outlook rules.
Is this possible?
TIA,
John
March 1, 2018 at 3:36 pm
I'm finding stuff like this...
http://geoffbi.blogspot.com/2012/04/data-driven-subcriptions-in-standard.html
...but not entirely positive it will work the way I need it to work. I'm going to tinker with the above suggestions but would appreciate any other input....just in case I'm going down the wrong path.
TIA,
John
March 1, 2018 at 4:29 pm
J M-314995 - Thursday, March 1, 2018 3:36 PMI'm finding stuff like this...http://geoffbi.blogspot.com/2012/04/data-driven-subcriptions-in-standard.html
...but not entirely positive it will work the way I need it to work. I'm going to tinker with the above suggestions but would appreciate any other input....just in case I'm going down the wrong path.
TIA,
John
Yes there are a lot of those all very much like doing data driven subscriptions. Some use SSIS, some don't but most are fine and that is generally what you want. Each will have different approaches - I'd go through several or more to see what matches your needs best. Some won't work for you, some will but only with some modifications.
The only thing I can think of that might take some playing around with is the subject for the email since that is driving the distribution that other person is doing.
Here are a few more to check -
Data Driven Subscription Workaround
Create SSRS Data Driven Subscriptions on Standard Edition
Simulate Reporting Services Data Driven Subscriptions on Unsupported Editions
Sue
March 2, 2018 at 8:50 am
J M-314995 - Thursday, March 1, 2018 1:50 PMI've read a lot of forum posts and a few blogs before resorting to creating this post. Nothing I've come across so far relates exactly to what I'm trying to do. If the solution is documented somewhere, I'm not doing the right search.I have a script that needs to run 87 times with 87 different parameters. The result each time it runs needs to produce an Excel file totaling 87 Excel files when it's completed. I'd really prefer not to have to create 87 different SSRS reports. As stated in the subject, we're using the Standard version so we don't have the built in capability of data driven subscriptions that the Enterprise version offers.
The ideal scenario (for me) would be that each of the 87 files are emailed (separately) to a person in our company with a customized Subject line related to the 87 chapters we have. This employee will setup Outlook rules to forward them on to 87 groups. She'll have to do this based on what is in the subject line which is why I've got to be able to customize each subject line. I'd send these reports directly to who they need to go to but the email addresses will change yearly and I'd prefer not to maintain a list like that so our employee said that she would maintain the list using Outlook rules.
Is this possible?
TIA,
John
Yes, it's possible. As you've discovered, a number of solutions already exist which may or may not meet your exact needs, If you discover that none of them meet your requirements, I could write something in VBScript that could be scheduled, or alternatively, as a Script Task in SSIS (also schedulable), but that would need to be on a paid basis, as the level of effort required is rather large, and strongly dependent on the exact criteria it would need to meet. If you want to discuss that further, please send me a private message here on this site.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 20, 2018 at 2:50 pm
I did figure out an SSIS solution. The manual SSRS subscription blogs/posts I've found were confusing and I wasn't quite sure how to set them up. I'm going to come back to those blog posts to try and figure that out at some point since I don't see our company ever upgrading to the Enterprise version of SQL server.
Thanks again for the responses.
John
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply