Unanswered: Need help improving the performance of my DTS
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:
I have MSDE SP3 installed
The DTS is running on the local and the Analysis Service is also on the same local machine