Creating Predictions Using Data Transformation Services

Analysis Services

Analysis Services

Creating Predictions Using Data Transformation Services

Use the Data Mining Prediction Query Task dialog box in a Data Transformation Services (DTS) package to run prediction queries based on a data mining model defined in Microsoft® SQL Server™ 2000 Analysis Services. Such queries can be used to create output tables that store the predictive results from a mining model analysis.

After you define the DTS package with the task, you can schedule the package to execute at a future date and time. The package can be executed once or at periodic intervals.

Note  To use the Data Mining Prediction Query task, you must install SQL Server 7.0 or SQL Server 2000, including SQL Server Enterprise Manager, as well as Analysis Manager on the server computer on which you want to execute the package containing the task.

To create a Relational Data Mining Prediction Query task