Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Integration Services
Technical Reference
Feature Reference
Integration Services F1 Help
SSIS Designer F1 Help
Task Properties UI Reference
ActiveX Script Task Editor (General Page)
ActiveX Script Task Editor (Script Page)
Analysis Services Execute DDL Task Editor (General Page)
Analysis Services Execute DDL Task Editor (DDL Page)
Analysis Services Processing Task Editor (General Page)
Analysis Services Processing Task Editor (Analysis Services Page)
Bulk Insert Task Editor (General Page)
Bulk Insert Task Editor (Connection Page)
Bulk Insert Task Editor (Options Page)
Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Query Tab)
Data Mining Query Task Editor (Output Tab)
Data Profiling Task Editor (General Page)
Single Table Quick Profile Form (Data Profiling Task)
Data Profiling Task Editor (Profile Requests Page)
Destination Database Files
Execute DTS 2000 Package Task Editor (General Page)
Execute DTS 2000 Package Task Editor (Inner Variables Page)
Execute DTS 2000 Package Task Editor (Outer Variables Page)
Execute Package Task Editor (General Page)
Execute Package Task Editor (Package Page)
Execute Process Task Editor (General Page)
Execute Process Task Editor (Process Page)
Execute SQL Task Editor (General Page)
Execute SQL Task Editor (Parameter Mapping Page)
Execute SQL Task Editor (Result Set Page)
File System Task Editor (General Page)
FTP Task Editor (General Page)
FTP Task Editor (File Transfer Page)
Message Queue Task Editor (General Page)
Message Queue Task Editor (Receive Page)
Message Queue Task Editor (Send Page)
Script Task Editor (General Page)
Script Task Editor (Script Page)
Select Objects to Transfer
Select Variables Page
Send Mail Task Editor (General Page)
Send Mail Task Editor (Mail Page)
Source database files
Transfer Database Task Editor (General Page)
Transfer Database Task Editor (Databases Page)
Transfer Error Messages Task Editor (General Page)
Transfer Error Messages Task Editor (Messages Page)
Transfer Jobs Task Editor (General Page)
Transfer Jobs Task Editor (Jobs Page)
Transfer Logins Task Editor (General Page)
Transfer Logins Task Editor (Logins Page)
Transfer SQL Server Objects Task Editor (General Page)
Transfer SQL Server Objects Task Editor (Objects Page)
Transfer Master Stored Procedures Task Editor (General Page)
Transfer Master Stored Procedures Task Editor (Stored Procedures Page)
Web Service Task Editor (General Page)
Web Service Task Editor (Input Page)
Web Service Task Editor (Output Page)
WMI Data Reader Task Editor (General Page)
WMI Data Reader Task Editor (WMI Options Page)
WMI Event Watcher Task Editor (General Page)
WMI Event Watcher Task Editor (WMI Options Page)
XML Task Editor (General Page)
Expand Minimize
This topic has not yet been rated - Rate this topic

Data Mining Query Task Editor (Query Tab)

SQL Server 2008

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 Data Mining Projects (Analysis Services - Data Mining).

Name

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

NoteNote

Task names must be unique within a package.

Description

Type a description of the Data Mining Query task.

Data mining query

Type a data mining query.

Related Topics: Data Mining Extensions (DMX) Reference

Build New Query

Create the data mining query using a graphical tool.

Related Topics:Data Mining Query

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.