Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Update an Analysis Services cube from stored proc?

    I'd like to be able to update an Analysis Services cube through a stored proc.

    Currently I can:
    - Make a DTS package that updates the cube
    - run xp_cmdshell which runs dtsrun which runs the DTS package.

    That is messy, easily broken, and hard to get good error info when an error occurs. Is there a better route?

  2. #2
    Join Date
    Jan 2008
    Did you get a reply on this?

    I am trying to automate the update of my information in the cube daily. I am surprised how complicated it is. I would think everyone would need to solve that problem if they are going to get reporting to be updated automatically.

Posting Permissions

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