Share via

IDTSForEachLoop100.Execute Method

  • Article

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Executes the ForEach loop process.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntax

'Declaration
Function Execute ( _
    pConnections As IDTSConnections100, _
    pVariables As IDTSVariables100, _
    pEvents As IDTSEvents100, _
    pLog As IDTSLogging100, _
    pTransaction As Object _
) As DTSExecResult
'Usage
Dim instance As IDTSForEachLoop100 
Dim pConnections As IDTSConnections100 
Dim pVariables As IDTSVariables100 
Dim pEvents As IDTSEvents100 
Dim pLog As IDTSLogging100 
Dim pTransaction As Object 
Dim returnValue As DTSExecResult 

returnValue = instance.Execute(pConnections, _
    pVariables, pEvents, pLog, pTransaction)

DTSExecResult Execute(
    IDTSConnections100 pConnections,
    IDTSVariables100 pVariables,
    IDTSEvents100 pEvents,
    IDTSLogging100 pLog,
    Object pTransaction
)

DTSExecResult Execute(
    [InAttribute] IDTSConnections100^ pConnections, 
    [InAttribute] IDTSVariables100^ pVariables, 
    [InAttribute] IDTSEvents100^ pEvents, 
    [InAttribute] IDTSLogging100^ pLog, 
    [InAttribute] Object^ pTransaction
)

abstract Execute : 
        pConnections:IDTSConnections100 * 
        pVariables:IDTSVariables100 * 
        pEvents:IDTSEvents100 * 
        pLog:IDTSLogging100 * 
        pTransaction:Object -> DTSExecResult

function Execute(
    pConnections : IDTSConnections100, 
    pVariables : IDTSVariables100, 
    pEvents : IDTSEvents100, 
    pLog : IDTSLogging100, 
    pTransaction : Object
) : DTSExecResult

Parameters

  • pTransaction
    Type: System.Object
    The collection of transactions.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.Wrapper.DTSExecResult
The result of the execution.

See Also

Reference

IDTSForEachLoop100 Interface

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace