Combine 2 datasources in one report?

I have loaded up the newest latests, greatest Visual Studio, SQL reporting etc. I have a need to pull in data from multiple sources. Currently I have DTS packages I have to run to dump information into 1 data source to report on. Has anybody figured out a way to have multipled data sources available when in the query builder?

I am scratching my head on this one.

Your report can have 2 datasets, each with a different datasource, but you cannot combine them into a single dataset within the report.

If you need to combine the data from 2 datasources into a single dataset, you'll need to handle this in your query/stored proc via a linked server or something similar.|||Thanks Andy for your quick response. It interesting that one can pull this off in MS Access with a simple ODBC but I cant in SQL reporting. I am not sure what you mean by linked server in this case.|||Linked Servers:
http://msdn2.microsoft.com/en-us/library/aa213778(SQL.80).aspx

Distributed Query:
http://msdn2.microsoft.com/en-us/library/aa172738(sql.80).aspx