Export (0) Print
Expand All

Automating Analysis Services Administrative Tasks

There are multiple approaches to the automation of Microsoft SQL Server 2005 Analysis Services (SSAS) administrative tasks. Microsoft SQL Server 2005 Integration Services (SSIS) contains a powerful set of tools that can be used to automate such tasks. For more information, see Processing Objects Using Integration Services.

The following topics explain the various aspects of managing an instance of Analysis Services:

Topic Description

Processing Objects Using Integration Services

Covers automated execution of DDL scripts, cube and mining model processing tasks, and data mining query tasks.

Scripting Objects Using SQL Server Management Studio

Shows how to create, alter or delete Analysis Services objects using scripts.

Scheduling Administrative Tasks Using SQL Server Agent

Discusses the ways in which you can arrange for automated running of jobs to accomplish administrative tasks.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft