SSRA Subscription, Need PATH to include YEAR as parameter

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.
LVL 1
Salad-DodgerAsked:
Who is Participating?
 
Russell FoxConnect With a Mentor Database DeveloperCommented:
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
 
Salad-DodgerAuthor Commented:
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
 
Salad-DodgerAuthor Commented:
Sigh - -  Foiled again.
0
 
Russell FoxDatabase DeveloperCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.