The Multi-Project component provides a visual representation of the project groups within a job. Multi-Project combines the properties of the Project and Synchronizer components. The Success and Error ports of the Multi-Project component can be connected to any of:
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 that can be executed in any order, and even in parallel, when used in multi-engine jobs.
Configuring
the Multi-Project component
Add the component to the job and connect it to its adjacent component.
In the Properties window:
Click the Projects Execution icon to select the projects to execute.
(Optional) Select the Commit Intermediate Work icon if you want all tasks performed by the included projects to be committed as soon as the projects have completed successfully.
(Optional) Select “Propagate Rollback” to enable transactionality for the contained projects. If selected, data is committed at the end of the write operation for a successful execution, and rolled back for an unsuccessful execution.
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.
Do not add a project multiple times.
The options available for project 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 continues even if an error occurs when loading data into a database.
Critical – define each single project as critical or noncritical. The failure of a critical project causes the Multi-Project component to signal failure.
