Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unhappy Unanswered: Processing of cubes in a scheduled DTS

    Hi everyone!

    I created a DTS which does some data transformations before processing some cubes. It finished processing in abt 10mins when I run this DTS manually. However, when I schedule this DTS to run, it took around 3 over hours to run. Does anybody know where the problem lies? I have been looking for a solution for this for a long time and I'm hoping that somebody can help me...

    Thank you!!

    Michelle

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Do you have the latest SP on the server? I seem to recall something in sp3 that is supposed to help this
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    My database is in a different server from the cube. The SQL server for this database is Server 2000, service pack 3a. The one for my cubes is version 7.00.623. Will the difference in version slow down the process?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •