Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baghs
Starting Member
1 Post |
 Posted - 2005-03-17 : 09:10:04
|
| Can anyone tell me if RS can fetch data from disparate data sources. The scenario is something like this; we need to fetch 40% of the data from SQL server cluster and 60% of the data from Datawarehouse in DB2.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-17 : 12:24:45
|
| You'll need to do this inside a stored procedure then in SQL Server. You'll need to create a linked server on the SQL Server, then use that linked server in your stored procedure to get to the DB2 database. So your stored procedure would handle all of the logic and return one result set to RS.Tara |
 |
|
|
|
|
|
Connecting to DB2 from Reporting Services