How to get rds file from report manager

Question

How to get rds file from report manager

gary1

SSC-Insane

Points: 21152
More actions
August 11, 2010 at 2:53 pm

#387560

Hi,
We are using SQL Server 2003 reporting services with SP1 and want to get the rds file, the data source file from report manager. Please advice me how to get that?
I'm able to get rdl files though but NOT rds file!:hehe:
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Kari Suresh Hall of Fame Points: 3712 More actions · Answer 1

[p]Go to properties of your project. Select "fullpath" of your project path in Properties window. find .rds file in that path directory. Otherwise you can use search option too.[/p]

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

gary1 SSC-Insane Points: 21152 More actions · Answer 2

Yes, I can get the full path from the project solution. But I want to get latest rds file (data source) from Report Manager .i.e the way we can get the rdl files from report manager. Because we do not have the rds file any where and we must need to get one from Report manager.

Here is the link describes how to get rdl files from Report Manager

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102320

Thanks

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

The data connection can be different on the server than when it's in the project (ie the properties of using windows credentials, sql credentials etc etc can all be modified, and are likely different to when you're in dev mode). Why not just take the connection string and either create a new connection in the project and enter/use the connection info you took from the server?

Steve.

Kari Suresh Hall of Fame Points: 3712 More actions · Answer 4

[p]Good idea from Steve.[/p][p]I have created a data source under shared data sources folder in my solution explorer and I am able to see the same .rds file in the windows folder.[/p]

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

l543123 SSC Eights! Points: 964 More actions · Answer 5

I use RSScripter.exe

http://weblogs.asp.net/akjoshi/archive/2009/01/29/using-rs-scripter-to-create-deployment-script-for-reporting-services.aspx