Data Flow How-to Topics (Integration Services)

This section contains procedures for working with data flow components—sources, transformations, destinations, and the paths that connect them—using the Integration Services tools that Business Intelligence Development Studio provides.

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.

SSIS Tutorial: Creating a Simple ETL Package

Step 4: Adding a Data Flow Task to the Package

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 Transformation

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

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.