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

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.

See Also

Reference

Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Query Tab)

Other Resources

Integration Services Error and Message Reference
Data Mining Designer

Help and Information

Getting SQL Server 2005 Assistance