Pushdown optimization stops at the transformation <transformation name> because it is connected to multiple targets.
You attempted to push a transformation to multiple targets for target-side partial pushdown optimization. The Integration Service cannot generate the SQL to push the transformation to both targets.