DMQueryTask.ExecuteQuery 方法

Executes the query found in the QueryString property.

命名空間：  Microsoft.SqlServer.Dts.Tasks.DMQueryTask
組件：  Microsoft.SqlServer.DMQueryTask (在 Microsoft.SqlServer.DMQueryTask.dll 中)

語法

'宣告
Public Function ExecuteQuery ( _
    connections As Connections, _
    variablesDispenser As VariableDispenser, _
    events As IDTSComponentEvents, _
    log As IDTSLogging, _
    txn As Object _
) As Boolean
'用途
Dim instance As DMQueryTask 
Dim connections As Connections 
Dim variablesDispenser As VariableDispenser 
Dim events As IDTSComponentEvents 
Dim log As IDTSLogging 
Dim txn As Object 
Dim returnValue As Boolean 

returnValue = instance.ExecuteQuery(connections, _
    variablesDispenser, events, log, _
    txn)

public bool ExecuteQuery(
    Connections connections,
    VariableDispenser variablesDispenser,
    IDTSComponentEvents events,
    IDTSLogging log,
    Object txn
)

public:
virtual bool ExecuteQuery(
    Connections^ connections, 
    VariableDispenser^ variablesDispenser, 
    IDTSComponentEvents^ events, 
    IDTSLogging^ log, 
    Object^ txn
) sealed

abstract ExecuteQuery : 
        connections:Connections * 
        variablesDispenser:VariableDispenser * 
        events:IDTSComponentEvents * 
        log:IDTSLogging * 
        txn:Object -> bool  
override ExecuteQuery : 
        connections:Connections * 
        variablesDispenser:VariableDispenser * 
        events:IDTSComponentEvents * 
        log:IDTSLogging * 
        txn:Object -> bool

public final function ExecuteQuery(
    connections : Connections, 
    variablesDispenser : VariableDispenser, 
    events : IDTSComponentEvents, 
    log : IDTSLogging, 
    txn : Object
) : boolean

參數

• connections
  型別：Microsoft.SqlServer.Dts.Runtime.Connections
  A collection of connections used by the task.

• variablesDispenser
  型別：Microsoft.SqlServer.Dts.Runtime.VariableDispenser
  A VariableDispenser object for locking variables.

• events
  型別：Microsoft.SqlServer.Dts.Runtime.IDTSComponentEvents
  An object that implements the IDTSComponentEvents interface.

• log
  型別：Microsoft.SqlServer.Dts.Runtime.IDTSLogging
  An object that implements the IDTSLogging interface.

• txn
  型別：System.Object
  The transaction object that the container is a part of. This value can be nullnull 參考 (在 Visual Basic 中為 Nothing).

傳回值

型別：System.Boolean
true indicates that the DMX query task executed successfully; false indicates that the DMX query task execution failed.

實作

IDMQueryTask.ExecuteQuery(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)

請參閱

參考

DMQueryTask 類別

Microsoft.SqlServer.Dts.Tasks.DMQueryTask 命名空間