SSRS Dynamic path for target folder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SSRS Dynamic path for target folder

SSRS Dynamic path for target folder

Rate Topic

Display Mode

Topic Options

Author

Message

brickpack

Posted Friday, February 27, 2009 4:06 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:37 PM
Points: 54, Visits: 449

Hello,

I have a monthly report that needs to be delivered to a file share. The catch is...the folder is different every month. The folder already exists and its name is based on the date. eg... \\server\d$\reports\03012009.

I need to to automate this report in SSRS. Is there any way to dynamically populate the path to the target folder?

Thanks

Post #666056

amadan

Posted Wednesday, January 16, 2013 8:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:46 AM
Points: 4, Visits: 115

Create a stored procedure and call create the path in that proc. Call the proc from the subscription selecting the Path.
Anil Madan

Post #1407875

« Prev Topic | Next Topic »

Permissions