Multiple choice sql-server

The step object in a DTS (data transformation service) package can run in parallel when there are no precedence constraints on it. Which of the following are step object precedence constraints?

  1. On failure

  2. Return codes

  3. On success

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DTS step precedence constraints control workflow execution: 'On success' runs the next step when the current one succeeds; 'On failure' runs when it fails; return codes allow branching based on specific exit codes. All three are valid constraint types.

Keep practicing — related questions