Check the options on DTSRun.  You can pass arguments to specify the server instance if you choose to do so; also can pass in global variable values which can be...

I think it is typical for left-to-right readers to use LEFT JOIN.  I almost always use LEFT when constructing a query from scratch.  I have noticed that the Query Builder...

We had had great success using Red-Gate comparison tools.

http://www.red-gate.com/sql/summary.htm

Very affordable and can product a script to syncronize in either direction.

I've found really great DTS help at the following URL: http://www.sqldts.com/

There is a specific article on using sp_OA* procedures to call DTS:

http://www.databasejournal.com/features/mssql/article.php/1459181