Post reply

Processing 2008 Cube using script task in SSIS 2008

  • March 30, 2011 at 11:18 pm

    #235975

    Hi,

    I'm having a few issues using the analysis services processing task editor for processing my cube through SSIS. I know this can be done using a script task, my problem is I'm a beginner when it comes to C# so was wondering if anyone could help em write this script. The cube is a 2008 analysis services cube and I'l be using a script task in SSIS 2008 using Microsoft Visual C# 2008.

    Thanks for all help. 🙂

  • March 31, 2011 at 12:37 am

    #1305797

    There may be no need for you to go to the extent of using a Script to process your cube. If you can generate the appropriate processing commands from within SSMS, you don't need a Script Task in SSIS - the AS Processing Task will work for you (even though the editor isn't as flexible). If you can set up the correct processing commands in SSMS, you can use the "Script" button to get the XMLA equivalent. If you can generate the XMLA from SSMS - or you know how to code the XMLA yourself without SSMS - then you can push that script directly into the AS Processing Task and "bypass" the SSIS editor.

    Select the AS Processing Task. Open the Properties Window (F4). Select the ProcessingCommands property, and paste your XMLA. Done.

    Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
    My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

  • March 31, 2011 at 7:29 pm

    #1306274

    Thanks for the reply.

    I am aware of this method but what if I wanted to use a constraint, which basically said only run the cube if certain conditions are met. Don't think doing it this way would help?

    Thanks

    Charlotte

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

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