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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-07-08 : 14:30:27
|
| I have a DTs package to Build.I have 2 servers as the sourceServer1 has a database QAA and Table 1Server2 has a database Tours and Table 1,Table 2,Table 3Now I have a server3 with Database EMP with Table 1 as the DestinationIn the Source ......Server1.QAA.Table 1 and Server2.Tours.Table1,Server2.Tours.Table2,Server2.Tours.Table3 are joined by a emp_id and the Server2.Tours.Table3 have multiple emp_ids So the dataset with the request_date as max should be pulled to the Destination.Please help me with this situation |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-08 : 19:39:32
|
| I don't understand. Could you explain in more detail? Why do you want to use DTS for this? Seems like pure T-SQL can do what you want.Tara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-07-08 : 21:08:51
|
| Basically there are 3 different databases residing in 3 different servers and I need to join the tables in 2 different databases in different servers and then pump the data to the destination database table.without using link servers can we join the table between 2 different database in 2 different server |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-09 : 12:31:50
|
| Why without using linked servers? Using linked servers is the preferred method for this. There's no reason to use DTS based on your description.Tara |
|
|
|
|
|
|
Joining Dataset to Destination