SQL Server Performance

hi-dts help

Discussion in 'SQL Server DTS-Related Questions' started by lara99, Nov 28, 2007.

  1. lara99 New Member

    hi all
    hi all, can you guys tell me the difference in using with completion and with success workflow.
    Thanks.
  2. martins New Member

    "On completion" means that the following task will execute, whether the previous task succeeded or failed. "On success" means the following task will only execute when the previous task succeeds. Also check you package properties, because if the "Fail package on first error" option is set it might disregard any "On completion" workflows and fail your package before executing the "On completion" tasks.

Share This Page