Agree about DTS (twice in one day - I must be mellowing).

People seem to see transfer and automatically jump into it and get into trouble.

I think of a transfer as move the data onto your server into staging tables (by any means) then run stored procedures to deal with it. The transfer could be DTS but I would keep it simple (prefer bulk insert if it needs to be fast - VB if not or you want to validate). In this way your processing is not bound to the source data - you can change the data source or transfer method without affecting anything else (maybe).

OLAP - again gets used where it's not really needed (was on a project where a large management consultancy A... and a huge software company M....S... tried to suggest an OLAP solution for a maximum 10,000 transaction database). I've never used it apart from investigation and helping people out.