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 ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
