The advantage that I found is just using select and insert sql statement to move data between local and link server is faster then DTS. DTS has more chance of failing to copy a table of 6 million record then the old style select and insert statement.
mom