So far I've only used DTS for inserting records and basic queries - now
I am stumped at a seemingly simple problem. Instead of adding a new
record from one DB to another I want to update the records. If I could
do a SQL query with two different database connections it'd be trivial,
but I don't see a way to do it?

But here's what I am try to do:

Connection one is a temporary Database Table - call it tempcost, it has
records with they key Itemkey and Location and has a field i'm
interested in NewMarketCost. Connection two is my database table INLOC
now for each record in tempcost based on the key Itemkey and Location
I'd like to change the Marketcost field in INLOC to the field in tempcost.

Seems simple enough, but I can't figure out how to do it with DTS!

Thanks for any help you can provide!


MS Sql Server LazyDBA home page