I would suggest using replication. Would probably be the easiest way to do it. See BOL for more details.

You could do this with DTS but the updating of each...

As far as I am aware you do not need to declare the variable in the SQL. Just type in your query i.e. select field1 from table1 and then click...