Existing Shared Data Source for New Reports?

• Thomas Stringer

  SSCarpal Tunnel

  Points: 4038

  More actions

  June 13, 2012 at 7:38 am

  #275758

  Here's the scenario:

  Current reporting server has DataSource1, DataSource2, Report1, Report2, and Report3. All is working and all is well.

  I don't have access to the project/solution that contains these objects, but I need to create new Reports based off of DataSource1 and DataSource2. My intention is to create a new SSRS project (BIDS) for the new reports. But how can I "import" or reference these existing Data Sources? I don't want to recreate them in the new project.

  ---

  
  Twitter: @SQLife
  Email: sqlsalt(at)outlook(dot)com

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 13, 2012 at 7:50 am

  #1500373

  Think this should work, but not tried it for a data source but.....

  Grab a copy of RSScriptor, use it to script out the rds and then import it into your new BIDS project.

  RSScriptor