how do i update one db.table based on another db.table from within a DTS package? is this possible? do i need a linked server?
I think you'll have to write a custom query for the same. No you don't need a linked server if both the databases under consideration are on the same server. Gaurav Moderator Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
If its a simple data updation then DTS is best bet, or even you can specify the query paramets to do so and as suggested by Gaurav LS is not a factor and its an overhead too. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
