O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How it works...

By inspecting the event data of the PipelineExecutionTrees event, you can see how the data will flow from the source components through the transformations, all the way to the destination components. In the preceding example, one main data path is used throughout the data flow, with two additional sub-paths for the two Lookup transformations.

The PipelineExecutionPlan event shows the individual operations that will be performed in order to facilitate the data movement through the pipeline. In the previous example, you can see that the buffers created in the source component (represented by the main data path in the execution tree) will be reused throughout this particular data flow. Because only non-blocking transformations ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required