Skip to Main Content
Pro SQL Server 2012 Integration Services
book

Pro SQL Server 2012 Integration Services

by Francis Rodrigues, Michael Coles, David Dye
June 2012
Intermediate to advanced content levelIntermediate to advanced
636 pages
14h 42m
English
Apress
Content preview from Pro SQL Server 2012 Integration Services

C H A P T E R  7

Source and Destination Adapters

“All rivers flow into the sea, yet the sea is not full.”

—King Solomon

In SSIS, the data flow is your primary tool for moving data from point A to point B and manipulating it along the way. The data flow is a powerful concept that allows you to encapsulate your data movement and transformation as a self-contained task of the control flow. The data flow moves your data from a source to a destination, like King Solomon’s river moves water from its source to the sea. This chapter introduces the data flow and discusses data flow source adapters, destination adapters, and the new Source and Destination Assistants.

The Data Flow

The data flow is contained within the confines of the Data Flow task ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2012 Integration Services

Microsoft® SQL Server® 2012 Integration Services

Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Pro SQL Server 2012 BI Solutions

Pro SQL Server 2012 BI Solutions

Randal Root, Caryn Mason

Publisher Resources

ISBN: 9781430236924Purchase book