Sequence.PrecedenceConstraints 属性

参考

定义

命名空间:: Microsoft.SqlServer.Dts.Runtime

程序集:: Microsoft.SqlServer.ManagedDTS.dll

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

返回 PrecedenceConstraint 对象的集合，这些对象说明将容器级容器和任务链接为有序控制流的优先约束

public:
 property Microsoft::SqlServer::Dts::Runtime::PrecedenceConstraints ^ PrecedenceConstraints { Microsoft::SqlServer::Dts::Runtime::PrecedenceConstraints ^ get(); };

public Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraints PrecedenceConstraints { get; }

member this.PrecedenceConstraints : Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraints

Public ReadOnly Property PrecedenceConstraints As PrecedenceConstraints

属性值

PrecedenceConstraints

一个 PrecedenceConstraints 集合。

实现

PrecedenceConstraints

示例

下面的代码示例创建一个对象，并创建三个 Sequence 任务，并在它们之间放置优先约束。 PrecedenceConstraints使用集合，循环访问每个约束中的Sequence约束，打印有关每个约束的信息。

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

namespace Sequence_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package package = new Package();  
            Sequence seq = (Sequence)package.Executables.Add("STOCK:SEQUENCE");  

            // Add a File System task.  
            Executable eFileTask1 = seq.Executables.Add("STOCK:FileSystemTask");  
            TaskHost thFileTask1 = eFileTask1 as TaskHost;  

            // Add a second File System task.  
            Executable eFileTask2 = seq.Executables.Add("STOCK:FileSystemTask");  
            TaskHost thFileTask2 = eFileTask2 as TaskHost;  

            // Add a Bulk Insert task.  
            Executable eBulkInsert = seq.Executables.Add("STOCK:BulkInsertTask");  
            TaskHost thBulkInsert = eBulkInsert as TaskHost;  

            // Add a precedence contraint between eFileTask1 and eFileTask2.  
            // Set the constraint to be that eFileTask2 cannot run   
            // until eFileTask1 completes.  
            PrecedenceConstraint pcFileTasks = seq.PrecedenceConstraints.Add(eFileTask1, eFileTask2);  

            // Add another precedence contraint. Add it between eFileTask2 and BulkInsert.  
            // Again, set the constraint to be that BulkInsert cannot run   
            // until eFileTask2 completes.  
            PrecedenceConstraint pcFiletoBulk = seq.PrecedenceConstraints.Add(eFileTask2, eBulkInsert);  
            // Obtain the precedence constraint collection, and display properties.  
            // Some properties are read/write and have not been set.  
            PrecedenceConstraints seqPCs = seq.PrecedenceConstraints;  
            int numPCs = seqPCs.Count;  
            Console.WriteLine("Number of precedence constraints in Sequence: {0}", numPCs);  
            Console.WriteLine("----------------------------------------");  

            foreach (PrecedenceConstraint pc in seqPCs)  
            {  
                Console.WriteLine("Constrained container  {0}", pc.ConstrainedExecutable);  
                Console.WriteLine("Description            {0}", pc.Description);  
                Console.WriteLine("Evaluation operation   {0}", pc.EvalOp);  
                Console.WriteLine("Evaluates true         {0}", pc.EvaluatesTrue);  
                Console.WriteLine("ID                     {0}", pc.ID);  
                Console.WriteLine("LogicalAnd             {0}", pc.LogicalAnd);  
                Console.WriteLine("Name                   {0}", pc.Name);  
                Console.WriteLine("Precedence Executable  {0}", pc.PrecedenceExecutable);  
                Console.WriteLine("Value                  {0}", pc.Value);  
                Console.WriteLine("-----------------------------------");  
            }  
            Executables seqExecs = seq.Executables;  
            int numExecs = seqExecs.Count;  
            Console.WriteLine("Number of Executables in Sequence: {0}", numExecs);  
        }  
    }  
}

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

Namespace Sequence_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim package As Package =  New Package()   
            Dim seq As Sequence = CType(package.Executables.Add("STOCK:SEQUENCE"), Sequence)  

            ' Add a File System task.  
            Dim eFileTask1 As Executable =  seq.Executables.Add("STOCK:FileSystemTask")   
            Dim thFileTask1 As TaskHost =  eFileTask1 as TaskHost   

            ' Add a second File System task.  
            Dim eFileTask2 As Executable =  seq.Executables.Add("STOCK:FileSystemTask")   
            Dim thFileTask2 As TaskHost =  eFileTask2 as TaskHost   

            ' Add a Bulk Insert task.  
            Dim eBulkInsert As Executable =  seq.Executables.Add("STOCK:BulkInsertTask")   
            Dim thBulkInsert As TaskHost =  eBulkInsert as TaskHost   

            ' Add a precedence contraint between eFileTask1 and eFileTask2.  
            ' Set the constraint to be that eFileTask2 cannot run   
            ' until eFileTask1 completes.  
            Dim pcFileTasks As PrecedenceConstraint =  seq.PrecedenceConstraints.Add(eFileTask1,eFileTask2)   

            ' Add another precedence contraint. Add it between eFileTask2 and BulkInsert.  
            ' Again, set the constraint to be that BulkInsert cannot run   
            ' until eFileTask2 completes.  
            Dim pcFiletoBulk As PrecedenceConstraint =  seq.PrecedenceConstraints.Add(eFileTask2,eBulkInsert)   
            ' Obtain the precedence constraint collection, and display properties.  
            ' Some properties are read/write and have not been set.  
            Dim seqPCs As PrecedenceConstraints =  seq.PrecedenceConstraints   
            Dim numPCs As Integer =  seqPCs.Count   
            Console.WriteLine("Number of precedence constraints in Sequence: {0}", numPCs)  
            Console.WriteLine("----------------------------------------")  

            Dim pc As PrecedenceConstraint  
            For Each pc In seqPCs  
                Console.WriteLine("Constrained container  {0}", pc.ConstrainedExecutable)  
                Console.WriteLine("Description            {0}", pc.Description)  
                Console.WriteLine("Evaluation operation   {0}", pc.EvalOp)  
                Console.WriteLine("Evaluates true         {0}", pc.EvaluatesTrue)  
                Console.WriteLine("ID                     {0}", pc.ID)  
                Console.WriteLine("LogicalAnd             {0}", pc.LogicalAnd)  
                Console.WriteLine("Name                   {0}", pc.Name)  
                Console.WriteLine("Precedence Executable  {0}", pc.PrecedenceExecutable)  
                Console.WriteLine("Value                  {0}", pc.Value)  
                Console.WriteLine("-----------------------------------")  
            Next  
            Dim seqExecs As Executables =  seq.Executables   
            Dim numExecs As Integer =  seqExecs.Count   
            Console.WriteLine("Number of Executables in Sequence: {0}", numExecs)  
        End Sub  
    End Class  
End Namespace

示例输出：

序列中的优先约束数：2

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

受约束容器 Microsoft.SqlServer.Dts.Runtime.TaskHost

说明

评估操作约束

计算 true True

ID {A4F5C0E6-A9A6-470D-9646-7FEAFE3B45AD}

LogicalAnd True

名称 {A4F5C0E6-A9A6-470D-9646-7FEAFE3B45AD}

优先级可执行文件 Microsoft.SqlServer.Dts.Runtime.TaskHost

值成功

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

受约束容器 Microsoft.SqlServer.Dts.Runtime.TaskHost

说明

评估操作约束

计算 true True

ID {665C52DE-232A-4593-ADF1-7C51949712B8}

LogicalAnd True

名称 {665C52DE-232A-4593-ADF1-7C51949712B8}

优先级可执行文件 Microsoft.SqlServer.Dts.Runtime.TaskHost

值成功

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

序列中的可执行文件数：3

注解

优先约束将容器和任务链接到有序工作流。可以在所有类型的容器和任务之间实现优先约束，但包除外。有关详细信息，请参阅优先约束。

适用于

通过

Sequence.PrecedenceConstraints 属性

定义

属性值

实现

示例

注解

适用于

其他资源