BreakpointTarget.BreakOnExpressionChange 属性
Gets or sets a Boolean that indicates whether the code is to continue running or break and stop executing when the expression changes.
命名空间： Microsoft.SqlServer.Dts.Runtime
程序集： Microsoft.SqlServer.ManagedDTS（在 Microsoft.SqlServer.ManagedDTS.dll 中）
语法
声明
Public Property BreakOnExpressionChange As Boolean
Get
Set
用法
Dim instance As BreakpointTarget
Dim value As Boolean
value = instance.BreakOnExpressionChange
instance.BreakOnExpressionChange = value
public bool BreakOnExpressionChange { get; set; }
public:
property bool BreakOnExpressionChange {
bool get ();
void set (bool value);
}
member BreakOnExpressionChange : bool with get, set
function get BreakOnExpressionChange () : boolean
function set BreakOnExpressionChange (value : boolean)
属性值
类型：System.Boolean
A Boolean indicating if the code is to break when an expression changes. true indicates that the package is to break; false indicates that the package will not break.
示例
The following code example retrieves the breakpoint target collection from the package and iterates through the breakpoints, displaying the properties for each breakpoint, including the BreakOnExpressionChange.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.BulkInsertTask;
namespace Breakpoint_API
{
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);
foreach (BreakpointTarget bpt in bptargets)
{
Console.WriteLine("BreakOnExpressionChange? {0}", bpt.BreakOnExpressionChange.ToString());
Console.WriteLine("Description {0}", bpt.Description);
Console.WriteLine("Enabled? {0}", bpt.Enabled);
Console.WriteLine("HitCount {0}", bpt.HitCount);
Console.WriteLine("HitTarget {0}", bpt.HitTarget);
Console.WriteLine("HitTest {0}", bpt.HitTest);
Console.WriteLine("ID {0}", bpt.ID);
Console.WriteLine("Owner {0}", bpt.Owner);
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Namespace Breakpoint_API
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)
Dim bpt As BreakpointTarget
For Each bpt In bptargets
Console.WriteLine("BreakOnExpressionChange? {0}", bpt.BreakOnExpressionChange.ToString())
Console.WriteLine("Description {0}", bpt.Description)
Console.WriteLine("Enabled? {0}", bpt.Enabled)
Console.WriteLine("HitCount {0}", bpt.HitCount)
Console.WriteLine("HitTarget {0}", bpt.HitTarget)
Console.WriteLine("HitTest {0}", bpt.HitTest)
Console.WriteLine("ID {0}", bpt.ID)
Console.WriteLine("Owner {0}", bpt.Owner)
Next
End Sub
End Class
End Namespace
Sample Output:
BreakOnExpressionChange? False
Description Break when the container receives the OnPreExecute event
Enabled? False
HitCount 0
HitTarget 0
HitTest Always
ID -2147483647
Owner Microsoft.SqlServer.Dts.Runtime.TaskHost