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

  • 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

Help and Information

Getting SQL Server 2005 Assistance