Converting an Embedded Dataflow to a Subflow

If you want to reuse an embedded dataflow in another dataflow, you must convert the embedded dataflow to a subflow. This is because embedded dataflows cannot be used in other dataflows. Once you convert an embedded dataflow to a subflow, it can be used like any other subflow.

Note: If the embedded dataflow has iteration enabled, iteration settings will be removed when it is converted to a subflow. Subflows do not support iteration.
  1. In Enterprise Designer, open the dataflow containing the embedded dataflow that you want to convert to a subflow.
  2. Right-click the embedded dataflow and select Convert Stage to Subflow.
  3. Enter a name for the new subflow and click OK.

The embedded dataflow is converted to a subflow and is made available in the Enterprise Designer palette under the User-Defined Stages folder.