Use the Output tab of the Data Mining Query Task Editor dialog box to specify the destination of the prediction query.
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.
Output Tab Options
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.
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.