This topic has not yet been rated - Rate this topic

PrecedenceConstraint Class

SQL Server 2008 R2

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	Returns the name of a constrained container. This property is read-only.
	CreationName	Returns 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	Returns the Boolean value of the Value property. 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	Returns the GUID of the precedence constraint. This property is read-only.
	LogicalAnd	Gets or sets a Boolean that indicates whether multiple constraints work together.
	Name	Gets or sets the unique name of the precedence constraint.
	PrecedenceExecutable	Returns the name of the precedence executable. This property is read-only.
	Site	Infrastructure.
	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.)
	Finalize	(Inherited from Object.)
	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. To load a package containing precedence constraints that are saved as .xml, use the Application.LoadPackage method.
	MemberwiseClone	(Inherited from Object.)
	SaveToXML	This method is not callable by your application code. To save 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