Professional SQL Server™ 2005 Integration Services

3.17. SQL Server Analysis Services Execute DDL and Processing Tasks

The SQL Server Analysis Services Execute DDL task is the Analysis Services equivalent of the Execute SQL task, but it is not quite as robust. The task simply executes a DDL statement against an Analysis Services system. The results of the DDL statement cannot be outputted to a variable as we showed in the Execute SQL task. Typically you would use something like DDL statements to create a cube, a dimension, or any other OLAP object.

To configure the task, go to the DDL page and select the Connection Manager that you wish to execute the DDL statement against in the Connection option. Then select whether the DDL statement will be directly inputted, pulled from a file, or pulled from a variable in the SourceType option. The last option is dynamic and will vary based on what you selected for the source of the DDL statement in the previous option. Essentially that option selects the variable or file where the DDL statement is stored or allows you to directly input the statement.

The SQL Server Analysis Services Processing task takes care of the processing of Analysis Services objects. The configuration of the task is done in the Analysis Services Processing Task Editor in the Analysis Services page. First, select the Analysis Services Connection Manager that you wish to process. Next, click the Add button and select the Analysis Services objects you'd like to process. After clicking OK, you'll be taken back to the Analysis ...