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 |
|
bdloving
Starting Member
4 Posts |
 Posted - 2008-07-17 : 10:19:22
|
| I have an Access query that joins a SQL Table with an Oracle ODBC Table.I want to implement this as a DTS to get it on the server instead of the users pc. But I cannot see how to do this in DTS?Basically I am trying to use the SQL table to limit the number of records returned from the Oracle tableSelect sql1.fields, oracle1.fields from Sql1 left join Oracle1 on sql1.key = oracle1.key |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:10:25
|
| Ddi you create linked server to oracle on sql server yet? |
 |
|
|
bdloving
Starting Member
4 Posts |
Posted - 2008-07-21 : 15:57:12
|
quote:
Originally posted by rmiao
Ddi you create linked server to oracle on sql server yet?
didn't know I had to create a linked server. Ok will dig into how to do that next. |
|
|
|
|
|
|
DTS Table Join?