Solved

Share Data Source between multiple projects

Posted on 2009-05-08
5
293 Views
Last Modified: 2012-05-06
Hi, is it possible to share a data source between multiple projects in the same solution? If so, how?

Thanks
0
Comment
Question by:mr_patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Hwkranger
ID: 24339109
No you cant.  But you can use your source control, write a script, or hand copy them to keep them in sync.
0
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 100 total points
ID: 24339975
As stated you can not share them, but you can import them from an existing item.  In Solution Explorer right click on the Project or Shared Data Sources > Add > Existing Item  and go find one or more data souces to include.  It will copy the rds file to this project.
SSRS-Add-Existing-DataSource.png
0
 

Author Comment

by:mr_patel
ID: 24339989
Hi CGLuttrell, I tried doing that, but it doesn't save the credentials. Is there anyway to save the credentials when I add an existing one?
Thanks.
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24340984
I believe that is a security consideration that MS does not maintain supplied credentials with just the .rds file.  It seems that I read that in MS documentation some where but I can not find it now.  I see references to "Credentials stored securely in the report server" though.  If it did keep username/password someone could just copy your rds file and gain access to a database.
0
 

Author Closing Comment

by:mr_patel
ID: 31579587
I ended up "adding existing" data source for 10 projects!
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question