Analysis Services
Automating and Scheduling Administrative Tasks
Microsoft® SQL Server™ 2000 Analysis Services integrates with Data Transformation Services (DTS) to help you administer your OLAP and data mining data. You can use DTS to automate processing, and you can use a batch file to automate archive and restoration of Analysis Services databases. The following topics describe how to automate these administrative tasks by using DTS or the command prompt.
| Topic | Description |
|---|---|
| Processing Objects Using Data Transformation Services | Describes how Analysis Services works with DTS to process objects. |
| Creating Predictions Using Data Transformation Services | Describes how DTS can be used to create a task that creates output tables containing the predictive column results from a data mining model analysis. |