Condividi tramite

Classe DMQueryTask

  • Articolo

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.

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.DMQueryTask.DMQueryTask

Spazio dei nomi  Microsoft.SqlServer.Dts.Tasks.DMQueryTask
Assembly:  Microsoft.SqlServer.DMQueryTask (in Microsoft.SqlServer.DMQueryTask.dll)

Sintassi

'Dichiarazione
<GuidAttribute("DF3C9778-2DB4-47C6-BA5A-AFB933958F3C")> _
Public Class DMQueryTask _
    Inherits Task _
    Implements IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist, IDMQueryTask
'Utilizzo
Dim instance As DMQueryTask

[GuidAttribute("DF3C9778-2DB4-47C6-BA5A-AFB933958F3C")]
public class DMQueryTask : Task, 
    IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist, IDMQueryTask

[GuidAttribute(L"DF3C9778-2DB4-47C6-BA5A-AFB933958F3C")]
public ref class DMQueryTask : public Task, 
    IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist, IDMQueryTask

[<GuidAttribute("DF3C9778-2DB4-47C6-BA5A-AFB933958F3C")>]
type DMQueryTask =  
    class 
        inherit Task 
        interface IDTSBreakpointSite 
        interface IDTSSuspend 
        interface IDTSComponentPersist 
        interface IDMQueryTask 
    end

public class DMQueryTask extends Task implements IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist, IDMQueryTask

Nel tipo DMQueryTask sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico DMQueryTask Initializes a new instance of the DMQueryTask class.

In alto

Proprietà

  Nome Descrizione
Proprietà pubblica DebugMode Gets or sets the Boolean value that indicates if a task should check if breakpoints are enabled.
Proprietà pubblica ExecutionValue Gets a user-defined object. This field is read-only. Esegue l'override di Task.ExecutionValue.
Proprietà pubblica InputConnection Gets or sets the connection string to an Analysis Services project or an Analysis Services database.
Proprietà pubblica InputParameters Gets or sets a collection of variables that is used in a parameterized Data Mining Extensions (DMX) query.
Proprietà pubblica ModelName Gets or sets the name of the mining model on which the query is based.
Proprietà pubblica ModelStructureName Gets or sets the name of the mining structure on which the query is based.
Proprietà pubblica OutputConnection Gets or sets the connection string to the OLE DB data source where the prediction query result will be stored.
Proprietà pubblica OutputTableName Gets or sets the name of the table where the results of the prediction query are written.
Proprietà pubblica OverwriteOutputTable Gets or sets the Boolean value that indicates if the prediction query should overwrite content in the destination table.
Proprietà pubblica QueryBuilderQueryString Infrastruttura. 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.
Proprietà pubblica QueryBuilderSpecification Infrastruttura. 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.
Proprietà pubblica QueryString Gets or sets a String that contains the text that the transformation uses to create a prediction query.
Proprietà pubblica ResultParameters Gets or sets a collection of Integration Services variables that is used to store the DMX query results.
Proprietà pubblica SuspendRequired Gets or sets a Boolean value 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.
Proprietà pubblica Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. Ereditato da Task.

In alto

Metodi

  Nome Descrizione
Metodo pubblico 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.
Metodo pubblico CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. Ereditato da Task.
Metodo pubblico Equals Determines whether two object instances are equal. Ereditato da DtsObject.
Metodo pubblico Execute Runs the task. Esegue l'override di Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).
Metodo pubblico ExecuteQuery Executes the query found in the QueryString property.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetConnectionID Gets a String containing the ID of the connection. Ereditato da Task.
Metodo pubblico GetConnectionName Gets a String containing the name of the connection. Ereditato da Task.
Metodo pubblico GetHashCode Returns the hash code for this instance. Ereditato da DtsObject.
Metodo pubblico GetType Ereditato da Object.
Metodo pubblico InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. Ereditato da Task.
Metodo pubblico LoadFromXML This method is not callable by your application code. Loads a package saved as .xml, use the Application.LoadPackage method.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
Metodo pubblico SaveToXML This method is not callable by your application code. Saves a package as .xml, use the Application.SaveToXml method.
Metodo pubblico SuspendExecution Indicates that the executable needs to suspend. This method is called by the runtime engine.
Metodo pubblico ToString Ereditato da Object.
Metodo pubblico Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. Ereditato da Task.
Metodo pubblico Validate Verifies that the component is properly configured. Esegue l'override di Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).

In alto

Osservazioni

For more information, see Attività Query di data mining.

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.DMQueryTask