This topic has not yet been rated - Rate this topic

PrecedenceConstraint Class

SQL Server 2012

Specifies the properties for configuring a precedence constraint between two containers. This class cannot be inherited.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraint

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

C++

JScript

public sealed class PrecedenceConstraint : DtsObject, 
	IDTSName, IDTSPersist, IComponent, IDisposable

The PrecedenceConstraint type exposes the following members.

Properties

	Name	Description
	ConstrainedExecutable	Gets the name of a constrained container. This property is read-only.
	CreationName	Gets the string used by the Integration Services runtime to create an instance of the PrecedenceConstraint object and add the object to the PrecedenceConstraints collection. This property is read-only.
	Description	Gets or sets a description for the constraint.
	EvalOp	Gets or sets the evaluation operations used by the precedence constraint.
	EvaluatesTrue	Gets a value that indicates whether the specified Value property evaluates to true. This property is read-only.
	Expression	Gets or sets the expression that the precedence constraint uses if EvalOp is set to Expression, ExpressionAndConstraint, or ExpressionOrConstraint.
	ID	Gets the GUID of the precedence constraint. This property is read-only.
	LogicalAnd	Gets or sets a Boolean value that indicates whether multiple constraints work together.
	Name	Gets or sets the unique name of the precedence constraint.
	Parent	Gets the parent container of the PrecedenceConstraint.
	PrecedenceExecutable	Gets the name of the precedence executable. This property is read-only.
	Site	Infrastructure. Gets or sets the site of the precedence constraint.
	Value	Gets or sets the constraint type of Success, Failure, or Completion.

Top

Methods

	Name	Description
	Dispose	This method is inherited from the IDisposable.Dispose method, which is a generic mechanism to explicitly tell an object to perform cleanup.
	Equals	Determines whether two object instances are equal. (Inherited from DtsObject.)
	GetHashCode	Returns the hash code for this instance. (Inherited from DtsObject.)
	GetType	(Inherited from Object.)
	LoadFromXML	This method is not callable by your application code. Loads a package containing precedence constraints that are saved as .xml, use the Application.LoadPackage method.
	SaveToXML	This method is not callable by your application code. Saves a package as .xml, use the Application.SaveToXml method.
	ToString	(Inherited from Object.)

Top

Events

	Name	Description
	Disposed	Adds an event handler to listen to the Disposed event on the precedence constraint.

Top

Remarks

You can specify the precedence and constrained executables that the precedence constraint connects, the expression and constraint that determine whether the constrained executable runs, and whether the precedence constraint works in concert with other precedence constraints.

Thread Safety

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

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD