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.

General Options

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

Note

Task names must be unique within a package.

Description
Type a description of the Data Mining Query task.

Build Query Tab Options

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 Mapping Tab Options

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 Set Tab Options

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.

See Also

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