Returns a BreakpointTargetEnumerator that can iterate through the BreakpointTargets collection.
命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
语法
声明
Public Function GetEnumerator As BreakpointTargetEnumerator
public BreakpointTargetEnumerator GetEnumerator ()
public:
BreakpointTargetEnumerator^ GetEnumerator ()
public BreakpointTargetEnumerator GetEnumerator ()
public function GetEnumerator () : BreakpointTargetEnumerator
返回值
A BreakpointTargetEnumerator for the BreakpointTargets collection.
示例
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
线程安全
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.
平台
开发平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
请参阅
参考
BreakpointTargets Class
BreakpointTargets Members
Microsoft.SqlServer.Dts.Runtime Namespace