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


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


Task names must be unique within a package.


Type a description of the Data Mining Query task.


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


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.

Community Additions