In SSIS (SQL Server Integration Services), "Completion" and "Success" are two different conditions that can be used in precedence constraints to control the flow of tasks and containers within a package. Here's the difference between them:
Completion:
Condition Definition:
A precedence constraint with the condition set to "Completion" means that the task or container has finished executing, regardless of whether it succeeded or failed.
Effect on Flow:
If the preceding task or container completes, the constrained task will execute, regardless of whether it encountered errors or not.
Use Case:
You might use "Completion" when you want a task to run regardless of whether the preceding task succeeded or failed. For example, you might want to execute a cleanup task after a data load operation, regardless of whether the load was successful.
Success:
Condition Definition:
A precedence constraint with the condition set to "Success" means that the preceding task or container has completed successfully, without encountering any errors.
Effect on Flow:
If the preceding task or container completes successfully, the constrained task will execute. If the preceding task fails, the constrained task will not execute.
Use Case:
You might use "Success" when you want a task to only run if the preceding task executed without any errors. For example, you might have a data validation task that should only proceed with further processing if the data validation is successful.
Key Takeaways:
"Completion" allows a task to run regardless of whether the preceding task succeeded or failed.
"Success" ensures that a task will only execute if the preceding task completed without any errors.
When to Use Which:
Use "Completion" when you want a task to execute even if the preceding task encountered errors. This is useful for cleanup operations or tasks that need to run regardless of errors.
Use "Success" when a task should only execute if the preceding task was successful. This is often used for tasks that depend on the successful completion of previous tasks.
Remember, the choice between "Completion" and "Success" will depend on the specific requirements of your ETL process and the desired behavior of your SSIS package.
Comments