BreakpointTargets.GetEnumerator Method

Returns a BreakpointTargetEnumerator that can iterate through the BreakpointTargets collection.

Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Sintaxis

'Declaración
Public Function GetEnumerator As BreakpointTargetEnumerator

public BreakpointTargetEnumerator GetEnumerator ()

public:
BreakpointTargetEnumerator^ GetEnumerator ()

public BreakpointTargetEnumerator GetEnumerator ()

public function GetEnumerator () : BreakpointTargetEnumerator

Valor devuelto

A BreakpointTargetEnumerator for the BreakpointTargets collection.

Ejemplo

The following code example creates a BreakpointTargetEnumerator using the GetEnumerator method, and then iterates over the collection.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.FileSystemTask;

namespace BreakpointTarget_Expression
{
    class Program
    {
        static void Main(string[] args)
            {
            Package pkg = new Package();
            TaskHost taskHost = (TaskHost)pkg.Executables.Add("STOCK:FileSystemTask");
            BreakpointTargets bptargets = pkg.GetBreakpointTargets(taskHost, false);
            // Create the enumerator.
            BreakpointTargetEnumerator myEnumerator = bptargets.GetEnumerator();
            Console.WriteLine("The collection contains the following values:");
                int i = 0;
            while ((myEnumerator.MoveNext()) && (myEnumerator.Current != null))
                Console.WriteLine("[{0}] {1}", i++, myEnumerator.Current.Description);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask
 
Namespace BreakpointTarget_Expression
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
            Dim taskHost As TaskHost = CType(pkg.Executables.Add("STOCK:FileSystemTask"), TaskHost)
            Dim bptargets As BreakpointTargets =  pkg.GetBreakpointTargets(taskHost,False) 
            ' Create the enumerator.
            Dim myEnumerator As BreakpointTargetEnumerator =  bptargets.GetEnumerator() 
            Console.WriteLine("The collection contains the following values:")
                Dim i As Integer =  0 
            While (myEnumerator.MoveNext()) &&(myEnumerator.Current <> Nothing)
            Console.WriteLine("[{0}] {1}",i = Console.WriteLine("[{0}] {1}",i + 1
            End While
        End Sub
    End Class
End Namespace

Sample Output:

The collection contains the following values:

[0] Break when the container receives the OnPreExecute event

[1] Break when the container receives the OnPostExecute event

[2] Break when the container receives the OnError event

[3] Break when the container receives the OnWarning event

[4] Break when the container receives the OnInformation event

[5] Break when the container receives the OnTaskFailed event

[6] Break when the container receives the OnProgress event

[7] Break when the container receives the OnQueryCancel event

[8] Break when the container receives the OnVariableValueChanged event

[9] Break when the container receives the OnCustomEvent event

Seguridad para subprocesos

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

BreakpointTargets Class
BreakpointTargets Members
Microsoft.SqlServer.Dts.Runtime Namespace