SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Adding TimeStamp to a Subscription
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

joe8079
Posting Yak Master

USA
127 Posts

Posted - 10/01/2012 :  14:38:59  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000