SSIS question

Heisenberg 181 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.
1,857 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,796 Reputation points Microsoft Employee
    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.

    No comments

  2. Heisenberg 181 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.