IDMQueryTask.ExecuteQuery 方法
此 API 支援 SQL Server 2012 基礎結構,但無法直接從您的程式碼使用。
Executes the query found in the QueryString property.
命名空間: Microsoft.SqlServer.Dts.Tasks.DMQueryTask
組件: Microsoft.SqlServer.DMQueryTask (在 Microsoft.SqlServer.DMQueryTask.dll 中)
語法
'宣告
Function ExecuteQuery ( _
connections As Connections, _
variables As VariableDispenser, _
events As IDTSComponentEvents, _
log As IDTSLogging, _
txn As Object _
) As Boolean
'用途
Dim instance As IDMQueryTask
Dim connections As Connections
Dim variables As VariableDispenser
Dim events As IDTSComponentEvents
Dim log As IDTSLogging
Dim txn As Object
Dim returnValue As Boolean
returnValue = instance.ExecuteQuery(connections, _
variables, events, log, txn)
bool ExecuteQuery(
Connections connections,
VariableDispenser variables,
IDTSComponentEvents events,
IDTSLogging log,
Object txn
)
bool ExecuteQuery(
Connections^ connections,
VariableDispenser^ variables,
IDTSComponentEvents^ events,
IDTSLogging^ log,
Object^ txn
)
abstract ExecuteQuery :
connections:Connections *
variables:VariableDispenser *
events:IDTSComponentEvents *
log:IDTSLogging *
txn:Object -> bool
function ExecuteQuery(
connections : Connections,
variables : VariableDispenser,
events : IDTSComponentEvents,
log : IDTSLogging,
txn : Object
) : boolean
參數
- connections
型別:Microsoft.SqlServer.Dts.Runtime.Connections
A collection of connections used by the task.
- variables
型別: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 objects 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.