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

Data Flow

This section is an introduction to building a package’s data flow in BIDS, with information on how to use sources, transformations, and destinations as the building blocks for the data logic of a package. Common or important transformations are highlighted and described, but this section does not provide a laundry list of all data flow components. Instead, this section focuses on common concepts and real-world usage scenarios, and it refers you to SQL Server Books Online for the complete list of all components.

As mentioned, it’s in no way a requirement that every SSIS package include one or more Data Flow tasks. For an example of an SSIS package that does not include a data flow, see the ProcessXMLData.sln solution, which is part of ...

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