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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2006-02-28 : 10:48:48
|
| Hi,I have an access database (call it John) that runs a query that joins table A from an Oracle Database (Matt) with table B from another Access database (Pete). John is using linked tables to do this. I would like to setup a job that executes this query on a regular basis. Can this be done using SQL Server DTS, or would I need to create linked servers to Matt and Pete on SQL Server and then just create a query that joins the two?If it can be done with DTS, how? I can see how data is transfered in DTS, but I'm not transfering data here. Would I need to import data from Matt and Pete into temp tables and then join them?Thanks,Drew |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-28 : 13:47:07
|
| Linked servers would be best for this since you aren't transforming data. You will need the proper ODBC data sources on your SQL Server though to do this.Tara Kizeraka tduggan |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-03-01 : 04:21:31
|
| Thank you almighty sql goddess. |
|
|
|
|
|
|
Using DTS to join tables from other servers