Data Flow How-to Topics (SSIS)
This section contains procedures for working with data flow components—sources, transformations, destinations, and the paths that connect them—using the SQL Server 2005 Integration Services (SSIS) tools that Business Intelligence Development Studio provides.
Learn How to Create Control Flow
The Integration Services Tutorial includes procedures for creating a data flow in the context of a working application that solves a real life business problem.
Creating a Simple ETL Package Tutorial
Adding a Data Flow Task to the Package
Add, Delete, and Configure Components
How to: Add a Component to a Data Flow
How to: Connect Components in a Data Flow
How to: Remove a Component from a Data Flow
How to: Set the Properties of a Data Flow Component Using a Component Editor
How to: Set the Properties of a Data Flow Component Using the Advanced Editor
How to: Set the Properties of a Data Flow Component in the Properties Window
How to: Set the Properties of a Path Using the Data Flow Path Editor
How to: View Path Metadata Using the Data Flow Path Editor
How to: Map Query Parameters to Variables in Data Flow Components
Extract, Transform, and Load Data
How to: Extract Data Using the OLE DB Source
How to: Extract Data Using the XML Source
How to: Load Data Using the OLE DB Destination
How to: Aggregate Values in a Dataset Using the Aggregate Transformation
How to: Split a Dataset Using the Conditional Split Transformation
How to: Convert Data to a Different Data Type Using the Data Conversion Transformation
How to: Derive Column Values Using the Derived Column Transformation
How to: Identify Similar Data Rows Using the Fuzzy Grouping Transformation
How to: Implement a Lookup Using the Lookup Transformation
How to: Extend a Dataset Using the Merge Join Transformation
How to: Configure the OLE DB Command Transformation
How to: Merge Inputs Using the Union All Transformation
How to: Bulk Load Data Using the SQL Server Destination
How to: Set Sort Attributes on an Output
See Also
Concepts
Other Resources
Integration Services How-to Topics