We have a requirement to tag the date/time to the file generated by the subscription that is an email subscription.
It looks like it is not possible to tag the timestamp to an email subscription but you can to a fileshare subscription.
It also looks like Data Driven subscription does not allow for changing @ReportName of the actual file name as opposed to just on the subject line.
Hopefully with SQL 2016 this is now possible, if not please advise ideas to accomplish this.
Maybe our only/best option to change it to a file share subscription, then have a separate windows script 'job' to email the file then move the file to an archive folder and/or delete it?
Thanks in advance.