Data Flow How-to Topics (Integration Services)

Learn How to Create Data 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.

Tutorial: Creating a Simple ETL Package

Task 4: Adding a Data Flow Task to the Package

Add, Delete, and Configure Components

How to: Add or Delete a Component in a Data Flow

How to: Connect Components in a Data Flow

How to: Set the Properties of a Data Flow Component

How to: Set the Properties of a Path by Using the Data Flow Path Editor

How to: View Path Metadata in the Data Flow Path Editor

How to: Map Query Parameters to Variables in a Data Flow Component

Extract, Transform, and Load Data

How to: Extract Data by Using the OLE DB Source

How to: Extract Data by Using the XML Source

How to: Load Data by Using the OLE DB Destination

How to: Aggregate Values in a Dataset by Using the Aggregate Transformation

How to: Split a Dataset by Using the Conditional Split Transformation

How to: Convert Data to a Different Data Type by Using the Data Conversion Transformation

How to: Derive Column Values by Using the Derived Column Transformation

How to: Identify Similar Data Rows by Using the Fuzzy Grouping Transformation

How to: Implement a Lookup in No Cache or Partial Cache Mode

How to: Implement a Lookup Transformation in Full Cache Mode Using the Cache Connection Manager

How to: Implement a Lookup Transformation in Full Cache Mode Using the OLE DB Connection Manager

How to: Create and Deploy a Cache for the Lookup Transformation

How to: Extend a Dataset by Using the Merge Join Transformation

How to: Configure the OLE DB Command Transformation

How to: Merge Data by Using the Union All Transformation

How to: Bulk Load Data by Using the SQL Server Destination

How to: Sort Data for the Merge and Merge Join Transformations

How to: Use a Recordset Destination

See Also

Concepts