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.

In This Section

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.

See Also


Processing in Analysis Services

Other Resources

Administering Analysis Services

Help and Information

Getting SQL Server 2005 Assistance