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 IDTSComponentEvents interface.
- txn
型別:System. . :: . .Object
The transaction object that the container is a part of. This value can be nullNothingnullptrunitnull 參考 (在 Visual Basic 中為 Nothing).
傳回值
型別:System. . :: . .Boolean
true indicates that the DMX query task executed successfully; false indicates that the DMX query task execution failed.