O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

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

Understanding Data Flow Sources, Transformations, and Destinations

SSIS is commonly used to move data from one location or file format to another. SSIS reads data using Data Flow sources, changes or processes the data using transformations if needed, and then writes the data to its new location or file format using Data Flow destinations. Packages aren't limited to just a single source or destination; complex packages might have multiple sources and/or destinations.

Worth repeating is that the Data Flow tab shows the workflow within a single Data Flow task. Packages can have more than one Data Flow task, each with its own self-contained workflow.

Sources

Sources are combined with connection managers (except the Raw File source) to retrieve data ...

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