If you can build it in VBscript DTS object you can loop through a
recordset updating the other table

>>> "QP " <mssqldba-ezmlmshield-x63718334.[Email address protected]
03/30/05 05:56AM >>>

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!



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page