December 10, 2001 at 7:14 pm
I'm new to DTS, using SQL 7.0. Is there a way to set up my source select statements using a join on both the source and the destination tables? Example: I'm trying to update a table on the Destination server with all new records from an identical table on the Source server. I simply want to insert the newest ones based on whether the Source table has key values greater than the Destination table. I need to at least have a WHERE clause comparing fields from both tables. I realize there are other ways to deal with this (replication, etc.), but I have other requirements for joining the source and destination tables as a criteria on my source selects.
December 11, 2001 at 7:15 am
I'm assuming you are using a Execute SQL task or a transform data task and if so, I believe you still have to have a linked server in order to do this. It has been a while since I tried this so I can try later today and let you know.
If anyone else knows for sure, please post.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 11, 2001 at 10:30 am
You'd need to use a linked server and join them as a single source.
You can use the multi data pump thing, but I've never liked it. I'd prefer to use a linked server or move my source and compare using native sql on the destination.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply