SSIS Sequence Containers

Michael Henderson 111 Reputation points
2020-08-21T15:50:11.927+00:00

I have a SQL Server Integration Services package that has multiple sequence containers.

If one sequence container fails, does the package stop?

Is there a setting so that subsequent sequence containers will run even if one sequence container fails.

Thanks in advance

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,847 questions
No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,686 Reputation points
    2020-08-24T03:33:52.8+00:00

    Hi ,

    Could you please share the screenshot of the tasks or containers in ssis package?

    We can set Precedence Constraints between the containers.

    19794-precedenceconstraint.png

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.

    No comments

1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 19,856 Reputation points
    2020-08-21T18:52:04.623+00:00

    The same technique like outlined here: SSIS - continue loop on error
    will work for your case.

    No comments