[转]Data Flow How-to Topics (SSIS)
本文转自：http://technet.microsoft.com/en-us/library/ms137612(v=sql.90).aspx
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.
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.
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
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
Concepts
Data Flow ElementsOther Resources
Integration Services How-to TopicsHelp and Information
Getting SQL Server 2005 Assistance
posted on 2014-03-03 11:15 freeliver54 阅读(227) 评论(0) 编辑 收藏 举报
