Export (0) Print
Expand All

Data Mining Query Task Editor (Query Tab)

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.

Note 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft