SQL Server Setup Help | |
Migrating Precedence Constraints | |
See Also |
Upgrading to SQL Server 2008 > Considerations for Upgrading Data Transformation Services > Migrating Data Transformation Services Packages > |
Precedence constraints in a SQL Server 2000 Data Transformation Services (DTS) package migrate to the PrecedenceConstraints collection of the new package.
Extending Functionality of Precedence Constraints
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.