In the workflow manager, you can specify constraint-based loading for a session. When you select this option, the integration service orders the target load on a row-by-row basis. For every row generated by an active source, the integration service loads the corresponding transformed row first to the primary key table, then to any foreign key tables. Constraint-based loading depends on the following requirements:
Active source. Related target tables must have the same active source.
Key relationships. Target tables must have key relationships.
Target connection groups. Targets must be in one target connection group.
Treat rows as insert. Use this option when you insert into the target. You cannot use updates with constraint-based loading.