[转]Data Flow How-to Topics (SSIS)

古城微笑少年丶 2022-03-31 05:22 130阅读 0赞

本文转自：[http://technet.microsoft.com/en-us/library/ms137612(v=sql.90).aspx][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.

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_ Add a Component to a Data Flow]

[How to: Connect Components in a Data Flow][How to_ Connect Components in a Data Flow]

[How to: Remove a Component from 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 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 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 Data Flow Component in the Properties Window]

[How to: Set the Properties of a Path Using the Data Flow Path Editor][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_ View Path Metadata Using the Data Flow Path Editor]

[How to: Map Query Parameters to Variables in Data Flow Components][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 OLE DB Source]

[How to: Extract Data Using the XML Source][How to_ Extract Data Using the XML Source]

[How to: Load Data Using the OLE DB Destination][How to_ Load Data Using the OLE DB Destination]

[How to: Aggregate Values in a Dataset Using the Aggregate Transformation][How to_ Aggregate Values in a Dataset Using the Aggregate Transformation]

[How to: Split a Dataset Using the Conditional Split 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_ Convert Data to a Different Data Type Using the Data Conversion Transformation]

[How to: Derive Column Values Using the Derived Column Transformation][How to_ Derive Column Values Using the Derived Column Transformation]

[How to: Identify Similar Data Rows Using the Fuzzy Grouping Transformation][How to_ Identify Similar Data Rows Using the Fuzzy Grouping Transformation]

[How to: Implement a Lookup Using the Lookup Transformation][How to_ Implement a Lookup Using the Lookup Transformation]

[How to: Extend a Dataset Using the Merge Join Transformation][How to_ Extend a Dataset Using the Merge Join Transformation]

[How to: Configure the OLE DB Command Transformation][How to_ Configure the OLE DB Command Transformation]

[How to: Merge Inputs Using the Union All Transformation][How to_ Merge Inputs Using the Union All Transformation]

[How to: Bulk Load Data Using the SQL Server Destination][How to_ Bulk Load Data Using the SQL Server Destination]

[How to: Set Sort Attributes on an Output][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][]

[http_technet.microsoft.com_en-us_library_ms137612_v_sql.90_.aspx]: http://technet.microsoft.com/en-us/library/ms137612%28v=sql.90%29.aspx
[Creating a Simple ETL Package Tutorial]: http://technet.microsoft.com/en-us/library/ms169917%28v=sql.90%29.aspx
[Adding a Data Flow Task to the Package]: http://technet.microsoft.com/en-us/library/ms170425%28v=sql.90%29.aspx
[How to_ Add a Component to a Data Flow]: http://technet.microsoft.com/en-us/library/ms141702%28v=sql.90%29.aspx
[How to_ Connect Components in a Data Flow]: http://technet.microsoft.com/en-us/library/ms140249%28v=sql.90%29.aspx
[How to_ Remove a Component from a Data Flow]: http://technet.microsoft.com/en-us/library/ms137910%28v=sql.90%29.aspx
[How to_ Set the Properties of a Data Flow Component Using a Component Editor]: http://technet.microsoft.com/en-us/library/ms140097%28v=sql.90%29.aspx
[How to_ Set the Properties of a Data Flow Component Using the Advanced Editor]: http://technet.microsoft.com/en-us/library/ms140156%28v=sql.90%29.aspx
[How to_ Set the Properties of a Data Flow Component in the Properties Window]: http://technet.microsoft.com/en-us/library/ms140164%28v=sql.90%29.aspx
[How to_ Set the Properties of a Path Using the Data Flow Path Editor]: http://technet.microsoft.com/en-us/library/ms140049%28v=sql.90%29.aspx
[How to_ View Path Metadata Using the Data Flow Path Editor]: http://technet.microsoft.com/en-us/library/ms137769%28v=sql.90%29.aspx
[How to_ Map Query Parameters to Variables in Data Flow Components]: http://technet.microsoft.com/en-us/library/ms139904%28v=sql.90%29.aspx
[How to_ Extract Data Using the OLE DB Source]: http://technet.microsoft.com/en-us/library/ms139767%28v=sql.90%29.aspx
[How to_ Extract Data Using the XML Source]: http://technet.microsoft.com/en-us/library/ms139886%28v=sql.90%29.aspx
[How to_ Load Data Using the OLE DB Destination]: http://technet.microsoft.com/en-us/library/ms139821%28v=sql.90%29.aspx
[How to_ Aggregate Values in a Dataset Using the Aggregate Transformation]: http://technet.microsoft.com/en-us/library/ms137839%28v=sql.90%29.aspx
[How to_ Split a Dataset Using the Conditional Split Transformation]: http://technet.microsoft.com/en-us/library/ms137530%28v=sql.90%29.aspx
[How to_ Convert Data to a Different Data Type Using the Data Conversion Transformation]: http://technet.microsoft.com/en-us/library/ms140321%28v=sql.90%29.aspx
[How to_ Derive Column Values Using the Derived Column Transformation]: http://technet.microsoft.com/en-us/library/ms137630%28v=sql.90%29.aspx
[How to_ Identify Similar Data Rows Using the Fuzzy Grouping Transformation]: http://technet.microsoft.com/en-us/library/ms142155%28v=sql.90%29.aspx
[How to_ Implement a Lookup Using the Lookup Transformation]: http://technet.microsoft.com/en-us/library/ms137820%28v=sql.90%29.aspx
[How to_ Extend a Dataset Using the Merge Join Transformation]: http://technet.microsoft.com/en-us/library/ms141029%28v=sql.90%29.aspx
[How to_ Configure the OLE DB Command Transformation]: http://technet.microsoft.com/en-us/library/ms141773%28v=sql.90%29.aspx
[How to_ Merge Inputs Using the Union All Transformation]: http://technet.microsoft.com/en-us/library/ms140172%28v=sql.90%29.aspx
[How to_ Bulk Load Data Using the SQL Server Destination]: http://technet.microsoft.com/en-us/library/ms141067%28v=sql.90%29.aspx
[How to_ Set Sort Attributes on an Output]: http://technet.microsoft.com/en-us/library/ms137653%28v=sql.90%29.aspx
[Data Flow Elements]: http://technet.microsoft.com/en-us/library/ms140080%28v=sql.90%29.aspx
[Integration Services How-to Topics]: http://technet.microsoft.com/en-us/library/ms141767%28v=sql.90%29.aspx
[Getting SQL Server 2005 Assistance]: http://technet.microsoft.com/en-us/library/ms166016%28v=sql.90%29.aspx