• In the Dataflow, use a multi-cast transformation. Then, define the two destinations and select the columns you want.

    Gerald Britton, Pluralsight courses