Export (0) Print
Expand All

Using Data Transformation Services with Analysis Services

SQL Server 2000

You can use Data Transformation Services (DTS) in Microsoft® SQL Server™ 2000 to process cubes, data mining models, and other objects, and to create prediction tasks based on mining models. For processing activities, a DTS task called the Analysis Services Processing task is provided, and for mining model predictions, the Data Mining Prediction Query task is provided. You can access both tasks within DTS Designer, which provides a user interface for defining DTS packages and tasks. After you define a package that contains an Analysis Services Processing task or a Data Mining Prediction Query task, you can schedule it to execute automatically. For more information, see Processing Objects Using Data Transformation Services.

See Also

DTS Basics

© 2015 Microsoft