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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-06 : 20:33:41
|
| Steve writes "I am using a very simple DTS with one Source and Destination and one data transformation between them. The issue is I need to access data in one of the tables in the destination database, to drive what information the source should pump. The source and destination are on different servers, I have only got read access on the source server so I cannot create a temp table.For example I have restricted information on 100 people in the destination, though I have extensive information on people in the source though there is thousands of people in the source and I only want extensive information on that 100 people.How can I use the destination to drive that the source pumps?" |
|
|
|
|
|
How do I use the destination in a DTS to drive what the source pumps?