I have a DTS which processes the Dimensions and THEN all thesubes of a Analysis Service's database. I have noticed that the DTS takes way too long to complete and would thus like to request any clues/guidance regarding how I canimporve the performance of the DTS?

Some things just in case:
  1. I have MSDE SP3 installed
  2. The DTS is running on the local and the Analysis Service is also on the same local machine
  3. I also have SP3 for AS installed

Many thanks in advance.