Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

dynamic text file in SSRS report Expand / Collapse
Posted Wednesday, March 20, 2013 2:05 PM


Group: General Forum Members
Last Login: Friday, August 1, 2014 8:41 AM
Points: 101, Visits: 437
hi all,

I have a SSRS report which needs to display the message ihat is contained in the text file. The message in the text file will change on regular basis.

How to get the value of a text file in SSRS report?

Any help on this.. thanks!

Post #1433469
Posted Wednesday, March 20, 2013 3:36 PM



Group: General Forum Members
Last Login: 2 days ago @ 2:09 AM
Points: 15,501, Visits: 13,163
SSRS doesn't support text files as a source, so you'll first need to get the contents of the text file in a place you can reach with SSRS, preferably a database.
If your text file arrives daily, you could perhaps upload it with SSIS.

An alternative might be to use .NET code from within the report itself, but I haven't done this before.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1433510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse