O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

The Integration Services Data Flow Engine

While the SSIS runtime is responsible for managing the execution of packages’ control flow, the heart of the SSIS data flow is the data flow engine. The data flow engine is responsible for interacting with data source components to extract data from flat files, relational databases, and other sources; for managing the transformations that manipulate the data that flows through the pipeline; and for interacting with the data destination components that load data into destination databases or other locations. But even more important than this, the data flow engine is responsible for managing the memory buffers that underlie the work that the source, destination, and transformation components are doing.

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