DMQueryTask Members

  • Article

This class provides the properties and methods for the Data Mining Query task, which runs prediction queries based on data mining models built in Analysis Services. This class cannot be inherited.

The following tables list the members exposed by the DMQueryTask type.

Public Constructors

  Name Description
DMQueryTask Initializes a new instance of the DMQueryTask class.

Top

Public Properties

  Name Description
ms214602.pubproperty(en-US,SQL.90).gif DebugMode A Boolean that indicates if a task should check if breakpoints are enabled.
ms214602.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns a user-defined object. This field is read-only.
ms214602.pubproperty(en-US,SQL.90).gif InputConnection Gets or sets the connection string to an Analysis Services project or an Analysis Services database.
ms214602.pubproperty(en-US,SQL.90).gif InputParameters Gets or sets a collection of variables that is used in a parameterized Data Mining Extensions (DMX) query.
ms214602.pubproperty(en-US,SQL.90).gif ModelName Gets or sets the name of the mining model on which the query is based.
ms214602.pubproperty(en-US,SQL.90).gif ModelStructureName Gets or sets the name of the mining structure on which the query is based.
ms214602.pubproperty(en-US,SQL.90).gif OutputConnection Gets or sets the connection string to the OLE DB data source where the prediction query result will be stored.
ms214602.pubproperty(en-US,SQL.90).gif OutputTableName Gets or sets the name of the table where the results of the prediction query are written.
ms214602.pubproperty(en-US,SQL.90).gif OverwriteOutputTable Gets or sets the Boolean value that indicates if the prediction query should overwrite content in the destination table.
ms214602.pubproperty(en-US,SQL.90).gif QueryBuilderQueryString  
ms214602.pubproperty(en-US,SQL.90).gif QueryBuilderSpecification  
ms214602.pubproperty(en-US,SQL.90).gif QueryString Gets or sets a String that contains the text that the transformation uses to create a prediction query.
ms214602.pubproperty(en-US,SQL.90).gif ResultParameters Gets or sets a collection of Integration Services variables that is used to store the DMX query results.
ms214602.pubproperty(en-US,SQL.90).gif SuspendRequired Gets or sets a Boolean that indicates if tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered.
ms214602.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms214602.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms214602.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Called by the run-time engine when a task or container is created, and is passed a BreakpointManager manager to allow the task to create, remove, and check the status of breakpoints. This method is called by the runtime and is not used in code.
ms214602.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms214602.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms214602.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms214602.pubmethod(en-US,SQL.90).gif ExecuteQuery Executes the query found in the QueryString property.
ms214602.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms214602.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms214602.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms214602.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms214602.pubmethod(en-US,SQL.90).gif InitializeTask  (inherited from Task )
ms214602.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms214602.pubmethod(en-US,SQL.90).gifms214602.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms214602.pubmethod(en-US,SQL.90).gifms214602.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms214602.pubmethod(en-US,SQL.90).gifms214602.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms214602.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
ms214602.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms214602.pubmethod(en-US,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the runtime engine.
ms214602.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms214602.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms214602.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the component is properly configured.

Top

Protected Methods

  Name Description
ms214602.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms214602.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

DMQueryTask Class
Microsoft.SqlServer.Dts.Tasks.DMQueryTask Namespace