SSIS question

Heisenberg 261 Reputation points
2021-11-17T21:55:12.327+00:00

hello, ive a DTS package where i want to run a simple script if any component of that sql package fails. This sql package has 15-20 execute sql tasks and object transfer tasks which runs one after another. If any of these tasks fails i want to run one script. How do i achieve this.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-11-18T05:53:05.773+00:00

    Hi @SQLServerBro,

    Thanks for your question.

    Please set the ForceExcutionResult to Success, and then try to run it again. For more information, please refer to ForceExecutionResult property in SSIS.
    150473-forceexecutionresult.png

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Heisenberg 261 Reputation points
    2021-11-18T17:04:49.933+00:00

    i think i didnt explain it correctly. i want a condition like

    "if any of the component fails in the package"
    then
    "execute SQL task" which will execute the script i want on any component failure.