Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Adding TimeStamp to a Subscription

Author  Topic 

joe8079
Posting Yak Master

127 Posts

Posted - 2012-10-01 : 14:38:59
I have a .RDL file, ABC.RDL, that goes out as a subscription once a day at 8:00AM and it goes out as a .TSV file through EMAIL not Windows File Share. The problem i'm having is I would to add the current timestamp to the file, but I dont see anywhere that I can change the name of the file to do this. I know that with windows fileshare option, I can just say ABC_@TIMESTAMP and that works, but this is not going to a file share so how do I add the timestamp to this file so it arrives to the user as:

ABC_@TIMESTAMP.TSV
   

- Advertisement -