Solved

SSRA Subscription, Need PATH to include YEAR as parameter

Posted on 2014-12-24
4
88 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 13

Accepted Solution

by:
Russell Fox earned 500 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 13

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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