I would say DTS as your situation, moving lots of data around, is what it was built for.

Having said that, our app syncs with a number of 3rd party apps for which I use linked servers, but I'm usually reading their tables and I'm much more familiar/comfortable with SQL.