How to create a Relational Data Mining Prediction Query task

To create a Relational Data Mining Prediction Query task

1. Start DTS Designer:
   1. On your desktop click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
      
      
   2. In the console tree, expand the server on which you want to create the package that will contain the Data Mining Prediction Query task.
      
      
   3. Right-click the Data Transformation Services folder, and then click New Package.
2. In DTS Designer, from the Task tool palette, drag the icon for the Data Mining Prediction Query task onto the DTS Designer design sheet. This icon appears here.

   

3. (Optional.) In the Data Mining Prediction Query Task dialog box, in the Name box, type a new name to replace the default name for the task.
   
   
4. (Optional.) In the Description box, type a task description. This description is used to identify the task in DTS Designer.
   
   
5. In the Server box, type the name of the Analysis server that contains the data mining model to be used as the source for the prediction query. The server name is the same as the computer name on the network. Do not use UNC or network paths.
   
   
6. From the Database list, select the database that contains the mining model to be queried.
   
   
7. If the mining model you want to use for the prediction query is not already highlighted in the Mining Models box, select a mining model from the box by clicking its name or icon. You can view some of the properties of the mining model in the Details box.
   
   
8. Click the Query tab, and then in the Input data source box, either type a valid ActiveX® Data Objects (ADO) connection string to the case table containing the input and predictable columns for the query, or click the edit (...) button to display the Data Link Properties dialog box, where you can build the connection string.

   In the Prediction query box, type the syntax, or click New Query to display Prediction Query Builder. The prediction query syntax must conform to the OLE DB for Data Mining specification. For more information about the OLE DB for Data Mining specification, see the Microsoft OLE DB Web page at the Microsoft Web site.

9. (Optional.) In the Output table box, type a new name for the output table to replace the default name.
   
   
10. Click OK to finish creating the task. To save the task in a DTS package in DTS Designer, on the Package menu, click Save. For information about the different ways you can save your package, see Saving a DTS Package.

See Also

ActiveX Script Task

Creating a Package with DTS Designer

Save DTS Package