Post reply

Processing an analysis Manager OLAP cube through DTS

  • December 14, 2005 at 7:54 am

    #111422

    We have this request to perform the processing of our OLAP cubes through scheduled DTS.

    Has anyone done this before, and could he share the sql syntax needed for this with me. He'd be my hero!

     

     

    Please Please Tell Me Now

    Is there something I should know?

    Is there something I should Say?

    That Would make You come My Way!

  • December 15, 2005 at 3:33 pm

    #609911

    The "Analysis Services Processing Task" in DTS is the task you need. Create a package that uses this task to process your cubes.

    Then schedule this to run using SQL Server Agent. Use a "Operating System Command (CmdExec)" job step that uses a command like

    DTSRUN /E /Ssqlservername /N"DTS Package Name"

    In this example, I assume you have saved the pacakge to "SQL Server". The name of that server is specified by the /S parameter. For more info on this command, look for DTSRun in BOL.

  • December 16, 2005 at 1:23 am

    #609981

    Thanks, Happy,

    that's exactly how I did it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply