Hi @Vaishu ,
A minimal execution unit at run-time is a package.
You can achieve what you need by redesigning your SSIS package:
- It is possible to disable any Container/Task at run-time dynamically via project/package boolean parameters set as True or False. You can set the conditions directly/programmatically on the Disable property on any SSIS task in the Control Flow by using Expressions.
- By using precedence constraints.
- Rearrange your single monolithic package with mutiple SSIS tasks as one task per package.
The first bullet is the easiest method.