Data Mining Query Task Editor (Output Tab)

Use the Output tab of the Data Mining Query Task Editor dialog box to specify the destination of the prediction query.

To learn about implementing data mining in packages, see Data Mining Query Task and Data Mining Projects (Analysis Services - 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.

Output Tab Options

  • Connection
    Select a connection manager in the list or click New to create a new connection manager.

  • New
    Create a new connection manager. Only the ADO.NET and OLE DB connection manager types can be used.

  • Output table
    Specify the table to which the prediction query writes its results.

  • Drop and re-create the output table
    Indicate whether the prediction query should overwrite content in the destination table by dropping and then re-creating the table.