Multi-Project provides a visual representation of the project groups within the job. Multi-Project combines the properties of the Project and Synchronizer components. The Success and Error ports of the Multi-Project component can either be connected to:
Multiple Project components.
Multiple Multi-Project components.
Multiple Project and Multi-Project components.
Single Finish component or Error component.
Use this component when your job consists of a large number of independent projects, in other words, projects that can be executed in any order, even in parallel when used in multi-engine jobs.
Configuring
the Multi-Project component
Add the component to the job and connect it with its adjacent component.
In the Properties window, click the Projects Execution icon to select the projects to execute.
To add projects to the group, right-click the Project name in the Navigator and select Add Projects.
To remove projects from the group, select the projects in the Navigator and and select Remove Projects.
A project group can contain only one instance of a project.
Trying to add a project multiple times will have no effect.
The options available for projects execution are:
Continue on Error – This option corresponds to the Continue on DB Write Errors property of a Project component. If you select this option, project execution will continue even if an error occurs when loading data into a database.
Critical – You can define each single project as critical or non-critical. The failure of a critical project causes the Multi-Project component to signal failure.
