Mac
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sigh - - Foiled again.
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
ASKER
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?