Export (0) Print
Expand All

IDMQueryTask Interface

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Defines the properties and methods for the data mining query task.

Namespace:  Microsoft.SqlServer.Dts.Tasks.DMQueryTask
Assembly:  Microsoft.SqlServer.DMQueryTask (in Microsoft.SqlServer.DMQueryTask.dll)

public interface class IDMQueryTask

The IDMQueryTask type exposes the following members.

Public propertyInputConnectionInfrastructure. Gets or sets the connection string to an Analysis Services project or an Analysis Services database.
Public propertyInputParametersInfrastructure. Gets or sets a collection of variables that is used in a parameterized Data Mining Extensions (DMX) query.
Public propertyModelNameInfrastructure. Gets or sets the name of the mining model on which the query is based.
Public propertyModelStructureNameInfrastructure. Gets or sets the name of the mining structure on which the query is based.
Public propertyOutputConnectionInfrastructure. Gets or sets the connection string to the OLE DB data source where the prediction query result will be stored.
Public propertyOutputTableNameInfrastructure. Gets or sets the name of the table where the results of the prediction query are written.
Public propertyOverwriteOutputTableInfrastructure. Gets or sets a value that indicates whether the prediction query should overwrite content in the destination table.
Public propertyQueryBuilderQueryStringInfrastructure. Gets or sets a string that specifies a data mining query that appears in the UI for data mining as the initial query string, which the user can the modify.
Public propertyQueryBuilderSpecificationInfrastructure. Gets or sets the information about the state of the Microsoft SQL Server Integration Services UI between sessions so that editing sessions can start from where a previous session finished.
Public propertyQueryStringInfrastructure. Gets or sets a String that contains the text that the transformation uses to create a prediction query.
Public propertyResultParametersInfrastructure. Gets or sets a collection of Integration Services variables that is used to store the DMX query results.

Public methodExecuteQueryInfrastructure. Executes the query found in the QueryString property.

Community Additions

© 2015 Microsoft