Data Mining Query Task Editor (Query Tab)

 

Applies To: SQL Server 2016

Use the Query tab of the Data Mining Query Task dialog box to create prediction queries based on a mining model. In this dialog box you can also bind parameters and result sets to variables.

To learn about implementing data mining in packages, see Data Mining Query Task and Data Mining Solutions.

Name
Provide a unique name for the Data Mining Query task. This name is used as the label in the task icon.

System_CAPS_ICON_note.jpg Note


Task names must be unique within a package.

Description
Type a description of the Data Mining Query task.

Data mining query
Type a data mining query.

Related Topics:  Data Mining Extensions (DMX) Reference

Build New Query
Create the data mining query using a graphical tool.

Related Topics: Data Mining Query

Parameter Name
Optionally, update the parameter name. Map the parameter to a variable by selecting a variable in the Variable Name list.

Variable Name
Select a variable in the list to map it to the parameter.

Add
Add to a parameter to the list.

Remove
Select a parameter, and then click Remove.

Result Name
Optionally, update the result set name. Map the result to a variable by selecting a variable in the Variable Name list.

After you have added a result by clicking Add, provide a unique name for the result.

Variable Name
Select a variable in the list to map it to the result set.

Result Type
Indicate whether to return a single row or a full result set.

Add
Add a result set to the list.

Remove
Select a result, and then click Remove.

Integration Services Error and Message Reference
Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Output Tab)
Data Mining Designer

Community Additions

ADD
Show: