Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Named qry to join 2 tables from 2 DBs in a DSV
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 06/20/2013 :  01:53:24  Show Profile  Reply with Quote
I'm looking for help with something that I believe should be possible to do in a data source view but am receiving an error for whenever I attempt it. My reading on the relevant content in MSDN ( )seems to back up my understanding that with the use of a named query I should be able to join two tables that exist in different data sources to create a new table in the data sourve view (DSV). The statement in the linked MSDN page suporting this is "A named query can also be used to join multiple database tables from one or more data sources into a single data source view table". It should be noted I am not having any problems using named queries to join tables that exist in the same data source.

Whenever I tried to do even the simplest named query to join two tables that exist in different data sources I receive an error that the first of the tables referenced can't be found. See the example in the picture below..

Has anyone successfully perfromed this task before or encountered this problems before? Any help would be appreciated.
Thanks in advance,

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000