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

Data Flow Elements

Other Resources

Integration Services How-to Topics

Help and Information

Getting SQL Server 2005 Assistance