?
Solved

SSRA Subscription, Need PATH to include YEAR as parameter

Posted on 2014-12-24
4
Medium Priority
?
125 Views
Last Modified: 2015-05-16
My SSRS (SQL2012) subscription copies a report to a Windows File Share and the path to that destination includes the year. (i.e. \\machinename\share\folder\2014\Folder).  

Each Year I have to change that path on Dec 31. Is there a way to have the YEAR be a parameter in the PATH dialog so it updates when needed?
Bonus points if SSRS could create the directory as needed if it didn't already exist.
0
Comment
Question by:Salad-Dodger
  • 2
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
Russell Fox earned 2000 total points
ID: 40519138
Sadly, no, that's not possible in vanilla SSRS:
When defining a subscription that uses file share delivery, you must specify an existing folder as the target folder. The report server does not create folders on the file system. -MSDN - File Share Delivery
It may be possible to change the subscription with an Agent job that runs once a year, but MS has deeply obfuscated the SSRS subscription information in the ReportServer databases. You could probably accomplish this with some C# code using the ReportViewer control, but that's deep magic.
0
 
LVL 1

Author Comment

by:Salad-Dodger
ID: 40519261
Well, thats a bummer, but not unexpected.
Assuming the year path exists, what about the part where I can alter the path entry in the SSRS subscription through code? Perhaps there is some way to use the parameter from which the report is generated?
0
 
LVL 1

Author Closing Comment

by:Salad-Dodger
ID: 40741397
Sigh - -  Foiled again.
0
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40780989
Sorry, didn't see you next comment. Here's an article on how to do something using SSIS: complicated, but might work. http://geekswithblogs.net/LifeLongTechie/archive/2009/11/24/calling-ssrs-report-using-either-t-sql-or-ssis.aspx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Integration Management Part 2
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question