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 Working with Data Mining.
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
Reference
Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Output Tab)
Other Resources
Integration Services Error and Message Reference
Data Mining Designer