Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

dynamic text file in SSRS report Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 2:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:41 AM
Points: 13,622, Visits: 10,508
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse