DTSBreakpointHitTest Enum

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menghitung nilai untuk jenis hitungan. Kelas ini bekerja dengan BreakpointTarget kelas .

public enum class DTSBreakpointHitTest

public enum DTSBreakpointHitTest

type DTSBreakpointHitTest = 

Public Enum DTSBreakpointHitTest

Warisan

Enum

DTSBreakpointHitTest

Bidang

Nama	Nilai	Deskripsi
Always	0	Eksekusi selalu ditangguhkan ketika titik henti tertembak.
Equal	2	Eksekusi ditangguhkan ketika berapa kali titik henti terjadi sama dengan jumlah hit.
Expression	4	Eksekusi ditangguhkan saat ekspresi berubah.
GreaterOrEqual	1	Eksekusi ditangguhkan ketika berapa kali titik henti terjadi sama dengan atau lebih besar dari jumlah hit.
Multiple	3	Eksekusi ditangguhkan ketika kelipatan jumlah hit terjadi.

Contoh

Contoh kode berikut memodifikasi nilai default menggunakan BreakpointTarget enumerasi ini.

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

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    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);  

            // Get the first breakpoint in the collection.  
            BreakpointTargetEnumerator myEnumerator = bptargets.GetEnumerator();  
            myEnumerator.MoveNext();  
            BreakpointTarget bptFirstOne = myEnumerator.Current;  

            // Display the initial values.  
            Console.WriteLine("Description              {0}", bptFirstOne.Description);  
            Console.WriteLine("Enabled?                 {0}", bptFirstOne.Enabled);  
            Console.WriteLine("HitTest                  {0}", bptFirstOne.HitTest);  
            Console.WriteLine("ID                       {0}", bptFirstOne.ID);  
            Console.WriteLine("--------------------------------------------");  

            // Modify the default value of HitTest.  
            myEnumerator.Reset();  
            myEnumerator.MoveNext();  
            bptFirstOne = myEnumerator.Current;  
            bptFirstOne.HitTest = DTSBreakpointHitTest.Equal;  

            // Display the values again, including the new HitTest.  
            Console.WriteLine("Description              {0}", bptFirstOne.Description);  
            Console.WriteLine("Enabled?                 {0}", bptFirstOne.Enabled);  
            Console.WriteLine("HitTest                  {0}", bptFirstOne.HitTest);  
            Console.WriteLine("ID                       {0}", bptFirstOne.ID);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace Microsoft.SqlServer.SSIS.Samples  
    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)   

            ' Get the first breakpoint in the collection.  
            Dim myEnumerator As BreakpointTargetEnumerator =  bptargets.GetEnumerator()   
            myEnumerator.MoveNext()  
            Dim bptFirstOne As BreakpointTarget =  myEnumerator.Current   

            ' Display the initial values.  
            Console.WriteLine("Description              {0}", bptFirstOne.Description)  
            Console.WriteLine("Enabled?                 {0}", bptFirstOne.Enabled)  
            Console.WriteLine("HitTest                  {0}", bptFirstOne.HitTest)  
            Console.WriteLine("ID                       {0}", bptFirstOne.ID)  
            Console.WriteLine("--------------------------------------------")  

            ' Modify the default value of HitTest.  
            myEnumerator.Reset()  
            myEnumerator.MoveNext()  
            bptFirstOne = myEnumerator.Current  
            bptFirstOne.HitTest = DTSBreakpointHitTest.Equal  

            ' Display the values again, including the new HitTest.  
            Console.WriteLine("Description              {0}", bptFirstOne.Description)  
            Console.WriteLine("Enabled?                 {0}", bptFirstOne.Enabled)  
            Console.WriteLine("HitTest                  {0}", bptFirstOne.HitTest)  
            Console.WriteLine("ID                       {0}", bptFirstOne.ID)  
        End Sub  
    End Class  
End Namespace  

Contoh Output:

Pemutus Deskripsi saat kontainer menerima peristiwa OnPreExecute

Diaktifkan? FALSE

HitTest Always

ID -2147483647

--------------------------------------------

Pemutus Deskripsi saat kontainer menerima peristiwa OnPreExecute

Diaktifkan? FALSE

HitTest Sama

ID -2147483647

Keterangan

Untuk menambahkan fleksibilitas dan daya ke titik henti, Anda dapat memodifikasi perilaku titik henti dengan mengonfigurasi jumlah hit titik henti, yang menentukan berapa kali titik henti terjadi sebelum mesin run-time ditangguhkan, dan jenis hit hit, yang berisi ekspresi yang menentukan kapan titik henti terpukul. Nilai ini digunakan dalam HitTest properti .