Migrating Precedence Constraints
SQL Server 2005
Precedence constraints in a SQL Server 2000 Data Transformation Services (DTS) package migrate to the PrecedenceConstraints collection of the new package.
After the package is migrated, you can extend precedence constraints in the following ways:
-
Use an expression with, or instead of, the execution result of the preceding executable to specify the conditions under which the constrained task runs. For more information, see Adding Expressions to Precedence Constraints.
-
Combine multiple precedence constraints to specify the conditions under which the constrained task runs. For more information, see Applying Multiple Precedence Constraints.
Other Resources
Migrating Data Transformation Services PackagesPrecedence Constraints
