数据流Data Flow

适用对象:是SQL Server,包含 Linux 版 是Azure SQL 数据库 是Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server Integration ServicesIntegration Services 提供 3 种不同类型的数据流组件:源、转换和目标。Integration ServicesIntegration Services provides three different types of data flow components: sources, transformations, and destinations. 源从数据存储区(如关系数据库中的表和视图、文件以及 Analysis ServicesAnalysis Services 数据库)中提取数据。Sources extract data from data stores such as tables and views in relational databases, files, and Analysis ServicesAnalysis Services databases. 转换修改、汇总和清除数据。Transformations modify, summarize, and clean data. 目标将数据加载到数据存储区,或创建内存中的数据集。Destinations load data into data stores or create in-memory datasets.

备注

在您使用自定义提供程序时,需要使用元数据列值更新 ProviderDescriptors.xml 文件。When you use custom providers, you need to update the ProviderDescriptors.xml file with the metadata column values.

此外, Integration ServicesIntegration Services 还提供将一个组件的输出连接到另一个组件的输入的路径。Additionally, Integration ServicesIntegration Services provides paths that connect the output of one component to the input of another component. 路径定义组件的序列,并允许您向数据流添加批注或查看列的源。Paths define the sequence of components, and let you add annotations to the data flow or view the source of the column.

您可以通过把源和目标的输出连接到转换和目标的输入来连接数据流组件。You connect data flow components by connecting the output of sources and destinations to the input of transformations and destinations. 在构造数据流的过程中,通常在将第二个以及后续组件添加到该数据流时连接这些组件。When constructing a data flow you typically connect the second and subsequent components as you add them to the data flow. 连接组件后,输入列即可用在对该组件的配置中。After you connect the component, the input columns are available for use in configuring the component. 如果没有可用的输入列,则在组件连接到数据流后才能完成对该组件的配置。When no input columns are available, you will have to complete the configuration of the component after it is connected to the data flow. 有关详细信息,请参阅 Integration Services 路径使用路径连接组件For more information, see Integration Services Paths and Connect Components with Paths.

以下关系图显示的数据流具有一个源、带有一个输入和一个输出的转换以及一个目标。The following diagram shows a data flow that has a source, a transformation with one input and one output, and a destination. 除了输入列、输出列和外部列之外,该关系图还包含输入、输出和错误输出。The diagram includes the inputs, outputs, and error outputs in addition to the input, output, and external columns.

数据流组件及其输入和输出Data flow components and their inputs and outputs

数据流实现Data Flow Implementation

将数据流任务添加到包的控制流是在包中实现数据流的第一步。Adding a Data Flow task to the control flow of a package is the first step in implementing a data flow in a package. 包可以包含多个数据流任务,每个数据流任务有自己的数据流。A package can include multiple Data Flow tasks, each with its own data flow. 例如,如果包需要按指定顺序运行数据流,或需要在数据流之间执行其他任务,则必须对每个数据流使用单独的数据流任务。For example, if a package requires that data flows be run in a specified sequence, or that other tasks be performed between the data flows, you must use a separate Data Flow task for each data flow.

控制流包含数据流任务后,就可以开始生成包所使用的数据流。After the control flow includes a Data Flow task, you can begin to build the data flow that a package uses. 有关详细信息,请参阅 数据流任务For more information, see Data Flow Task.

创建数据流包括下列步骤:Creating a data flow includes the following steps:

  • 添加一个或多个源以便从字段和数据库提取数据,并且添加连接管理器以便连接到这些源。Adding one or more sources to extract data from files and databases, and add connection managers to connect to the sources.

  • 添加满足包的业务要求的转换。Adding the transformations that meet the business requirements of the package. 数据流并非必须包含转换。A data flow is not required to include transformations.

    某些转换要求连接管理器。Some transformations require a connection manager. 例如,查找转换使用连接管理器来连接到包含查找数据的数据库。For example, the Lookup transformation uses a connection manager to connect to the database that contains the lookup data.

  • 通过将源和转换的输出连接到转换和目标的输入来连接数据流组件。Connecting data flow components by connecting the output of sources and transformations to the input of transformations and destinations.

  • 添加一个或多个目标以便将数据加载到字段和数据库之类的数据存储区,并且添加连接管理器以便连接到这些源。Adding one or more destinations to load data into data stores such as files and databases, and adding connection managers to connect to the data sources.

  • 配置针对组件的错误输出以便处理问题。Configuring error outputs on components to handle problems.

    在运行时,行级错误可能在数据流组件转换数据、执行查找或计算表达式时发生。At run time, row-level errors may occur when data flow components convert data, perform a lookup, or evaluate expressions. 例如,值为字符串的数据列不能转换为整数,或尝试除以零的表达式。For example, a data column with a string value cannot be converted to an integer, or an expression tries to divide by zero. 两种操作都导致错误,而包含错误的行可以用错误流分别进行处理。Both operations cause errors, and the rows that contain the errors can be processed separately using an error flow. 有关在包数据流中如何使用错误流的详细信息,请参阅 数据中的错误处理For more information about how to use error flows in package data flow, see Error Handling in Data.

  • 包括批注以使数据流自文档化。Include annotations to make the data flow self-documenting. 有关详细信息,请参阅 在包中使用批注For more information, see Use Annotations in Packages.

备注

创建新包时,还可以使用向导来帮助您正确配置连接管理器、源和目标。When you create a new package, you can also use a wizard to help you configure connection managers, sources, and destinations correctly. 有关详细信息,请参阅 Create Packages in SQL Server Data ToolsFor more information, see Create Packages in SQL Server Data Tools.

“数据流” 选项卡处于活动状态时,工具箱将包含可添加到数据流的源、转换和目标。When the Data Flow tab is active, the Toolbox contains the sources, transformations, and destinations that you can add to the data flow.

表达式Expressions

很多数据流组件(源、转换和目标)都支持使用属性表达式来表示它们的某些属性。A number of the data flow components-sources, transformations, and destinations-support the use of property expressions in some of their properties. 属性表达式是在加载包时用于替换属性值的表达式。A property expression is an expression that replaces the value of the property when the package is loaded. 在运行时,包使用更新后的属性值。At run time, the package uses the updated property values. 表达式是使用 Integration ServicesIntegration Services 表达式语法生成的,并且可以包括 Integration ServicesIntegration Services 函数、运算符、标识符和变量。The expressions are built using the Integration ServicesIntegration Services expression syntax and can include Integration ServicesIntegration Services functions, operators, identifiers, and variables. 有关详细信息,请参阅 Integration Services (SSIS) 表达式Integration Services (SSIS) 表达式在包中使用属性表达式For more information, see Integration Services (SSIS) Expressions, Integration Services (SSIS) Expressions, and Use Property Expressions in Packages.

如果在 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)中构造包,则支持属性表达式的任何数据流组件的属性将显示在它们所属的数据流任务上。If you construct a package in SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), the properties of any data flow components that support property expressions are exposed on the Data Flow task to which they belong. 若要添加、更改或删除数据流组件的属性表达式,请单击数据流任务,然后使用任务的“属性”窗口或编辑器来添加、更改或删除属性表达式。To add, change, and remove the property expressions of data flow components, click the Data Flow task, and then use the Properties window or the editor for the task to add, change, or delete property expressions. 数据流任务自身的属性表达式也在“属性”窗口中进行管理。Property expressions for the Data Flow task itself are managed in the Properties window.

如果数据流包含任何使用表达式的组件,则表达式也显示在“属性”窗口中。If the data flow contains any components that use expressions, the expressions are also exposed in the Properties window. 若要查看表达式,请选择该组件所属的数据流任务。To view expressions, select the Data Flow task to which the component belongs. 可以按类别或者字母顺序查看属性。You can view properties by categories, or in alphabetical order. 如果在“属性”窗口中使用“按分类顺序”视图,任何没有用于特定属性的表达式将显示在 “杂项” 类别中。If you use the categorized view in the Properties window, any expressions that are not used in a specific property are listed in the Misc category. 如果使用字母顺序视图,则按数据流组件的名称顺序列出表达式。If you use the alphabetical view, expressions are listed in order of the name of the data flow component.

Sources

Integration ServicesIntegration Services中,源是使数据流中的其他组件可以访问来自不同外部数据源的数据的数据流组件。In Integration ServicesIntegration Services, a source is the data flow component that makes data from different external data sources available to the other components in the data flow. 可以从平面文件、XML 文件、Microsoft Excel 工作簿和包含原始数据的文件中提取数据。You can extract data from flat files, XML files, Microsoft Excel workbooks, and files that contain raw data. 还可以通过访问数据库中的表和视图以及通过运行查询来提取数据。You can also extract data by accessing tables and views in databases and by running queries.

数据流可以包含单个或多个源。A data flow can include a single source or multiple sources.

数据流的源通常具有一个常规输出。The source for a data flow typically has one regular output. 常规输出包含输出列,这些输出列是由源添加到数据流中的。The regular output contains output columns, which are columns the source adds to the data flow.

常规输出引用外部列。The regular output references external columns. 外部列是源中的列。An external column is a column in the source. 例如 AdventureWorks 数据库的 Product 表中的 MadeFlag 列是可以添加常规输出的外部列。For example, the MadeFlag column in the Product table of the AdventureWorks database is an external column that can be added to the regular output. 外部列的元数据包含诸如源列的名称、数据类型和长度等信息。Metadata for external columns includes such information as the name, data type, and length of the source column.

源的错误输出包含与常规输出相同的列,此外,还包括提供有关错误信息的两个额外列。An error output for a source contains the same columns as the regular output, and also contains two additional columns that provide information about errors. Integration ServicesIntegration Services 对象模型不限制源可拥有的常规输出和错误输出的数目。The Integration ServicesIntegration Services object model does not restrict the number of regular outputs and error outputs that sources can have. 除脚本组件外, Integration ServicesIntegration Services 包含的大多数源都具有一个常规输出,许多源具有一个错误输出。Most of the sources that Integration ServicesIntegration Services includes, except the Script component, have one regular output, and many of the sources have one error output. 对于自定义源,可以通过编码方式实现多个常规输出和错误输出。Custom sources can be coded to implement multiple regular outputs and error outputs.

所有输出列都可用作数据流中下一个数据流组件的输入列。All the output columns are available as input columns to the next data flow component in the data flow.

您也可以编写自定义源。You can also write custom sources. 有关详细信息,请参阅 开发自定义数据流组件开发特定类型的数据流组件For more information, see Developing a Custom Data Flow Component and Developing Specific Types of Data Flow Components.

以下源拥有可以使用属性表达式来更新的属性:The following sources have properties that can be updated by property expressions:

可供下载的源Sources Available for Download

下表列出了可从 MicrosoftMicrosoft 网站下载的其他源。The following table lists additional sources that you can download from the MicrosoftMicrosoft website.

数据源Source 描述Description
Oracle 源Oracle Source Oracle 源是 MicrosoftMicrosoft Connector for Oracle by Attunity 的源组件。The Oracle source is the source component of the MicrosoftMicrosoft Connector for Oracle by Attunity. MicrosoftMicrosoft Connector for Oracle by Attunity 还包括连接管理器和目标。The MicrosoftMicrosoft Connector for Oracle by Attunity also includes a connection manager and a destination. 有关详细信息,请访问下载页 Microsoft Connectors for Oracle 和 Teradata by AttunityFor more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.
SAP BI 源SAP BI Source SAP BI 源是 MicrosoftMicrosoft Connector for SAP BI 的源组件。The SAP BI source is the source component of the MicrosoftMicrosoft Connector for SAP BI. MicrosoftMicrosoft Connector for SAP BI 还包括连接管理器和目标。The MicrosoftMicrosoft Connector for SAP BI also includes a connection manager and a destination. 有关详细信息,请访问下载页 Microsoft SQL Server 功能包For more information, see the download page, Microsoft SQL Server Feature Pack.
Teradata 源Teradata Source Teradata 源是 MicrosoftMicrosoft Connector for Teradata 的源组件。The Teradata source is the source component of the MicrosoftMicrosoft Connector for Teradata by Attunity. MicrosoftMicrosoft Connector for Teradata 还包括连接管理器和目标。The MicrosoftMicrosoft Connector for Teradata by Attunity also includes a connection manager and a destination. 有关详细信息,请访问下载页 Microsoft Connectors for Oracle and Teradata by AttunityFor more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

有关如何利用 MicrosoftMicrosoft Connector for Oracle by Attunity 提高性能的演示,请参阅 Microsoft Connector for Oracle by Attunity 的性能(SQL Server 视频)For a demonstration on how to leverage the performance gains of the MicrosoftMicrosoft Connector for Oracle by Attunity, see Performance of Microsoft Connector for Oracle by Attunity (SQL Server Video).

转换Transformations

转换的功能非常广泛。The capabilities of transformations vary broadly. 转换可以执行如更新、汇总、清除、合并和分发数据等任务。Transformations can perform tasks such as updating, summarizing, cleaning, merging, and distributing data. 可以修改列中的值、查找表中的值、清理数据以及聚合列值。You can modify values in columns, look up values in tables, clean data, and aggregate column values.

转换的输入和输出定义传入和传出数据的列。The inputs and outputs of a transformation define the columns of incoming and outgoing data. 根据对数据执行的操作,一些转换具有一个输入和多个输出,而其他转换具有多个输入和一个输出。Depending on the operation performed on the data, some transformations have a single input and multiple outputs, while other transformations have multiple inputs and a single output. 转换还可以包含错误输出,它们提供关于发生的错误以及失败的数据信息:例如,无法转换为整数数据类型的字符串数据。Transformations can also include error outputs, which provide information about the error that occurred, together with the data that failed: For example, string data that could not be converted to an integer data type. Integration ServicesIntegration Services 对象模型不限制转换可以包含的输入、常规输出和错误输出的数目。The Integration ServicesIntegration Services object model does not restrict the number of inputs, regular outputs, and error outputs that transformations can contain. 您可以创建自定义转换,这些转换可实现多个输入、常规输出和错误输出的任意组合。You can create custom transformations that implement any combination of multiple inputs, regular outputs, and error outputs.

转换的输入被定义为一个或多个输入列。The input of a transformation is defined as one or more input columns. 某些 Integration ServicesIntegration Services 转换还可以引用外部列作为输入。Some Integration ServicesIntegration Services transformations can also refer to external columns as input. 例如 OLE DB 命令转换的输入包含外部列。For example, the input to the OLE DB Command transformation includes external columns. 输出列是转换添加到数据流的列。An output column is a column that the transformation adds to the data flow. 常规输出和错误输出都包含输出列。Both regular outputs and error outputs contain output columns. 这些输出列转而充当数据流中下一个组件(其他转换或目标)的输入列。These output columns in turn act as input columns to the next component in the data flow, either another transformation or a destination.

以下转换有可以用属性表达式来更新的属性:The following transformations have properties that can be updated by property expressions:

有关详细信息,请参阅 Integration Services TransformationsFor more information, see Integration Services Transformations.

目标Destinations

目标是将数据流中的数据写入特定数据存储区或创建内存中的数据集的数据流组件。A destination is the data flow component that writes the data from a data flow to a specific data store, or creates an in-memory dataset. 可以将数据加载到平面文件、处理分析对象以及为其他进程提供数据。You can load data into flat files, process analytic objects, and provide data to other processes. 还可以通过访问数据库中的表和视图以及运行查询来提取数据。You can also load data by accessing tables and views in databases and by running queries.

数据流可以包含多个将数据加载到不同数据存储区的目标。A data flow can include multiple destinations that load data into different data stores.

一个 Integration ServicesIntegration Services 目标必须具有至少一个输入。An Integration ServicesIntegration Services destination must have at least one input. 输入包含来自其他数据流组件的输入列。The input contains input columns, which come from another data flow component. 输入列映射到目标中的列。The input columns are mapped to columns in the destination.

许多目标还具有一个错误输出。Many destinations also have one error output. 目标的错误输出包含输出列,该输出列通常包含向目标数据存储区写入数据时发生的错误信息。The error output for a destination contains output columns, which typically contain information about errors that occur when writing data to the destination data store. 错误的发生有许多不同的原因。Errors occur for many different reasons. 例如,列可能包含空值,而目标列不能设置为空值。For example, a column may contain a null value, whereas the destination column cannot be set to null.

Integration ServicesIntegration Services 对象模型不限制目标可包含的常规输入和错误输出的数目,因此,您可以创建具有多个输入和多个错误输出的自定义目标。The Integration ServicesIntegration Services object model does not restrict the number of regular inputs and error outputs that destinations can have, and you can create custom destinations that implement multiple inputs and error outputs.

您也可以编写自定义目标。You can also write custom destinations. 有关详细信息,请参阅 开发自定义数据流组件开发特定类型的数据流组件For more information, see Developing a Custom Data Flow Component and Developing Specific Types of Data Flow Components.

以下目标拥有可以使用属性表达式来更新的属性:The following destinations have properties that can be updated by property expressions:

可供下载的目标Destinations Available for Download

下表列出了可从 MicrosoftMicrosoft 网站下载的其他目标。The following table lists additional destinations that you can download from the MicrosoftMicrosoft website.

数据源Source 描述Description
Oracle 目标Oracle Destination Oracle 目标是 MicrosoftMicrosoft Connector for Oracle by Attunity 的目标组件。The Oracle destination is the destination component of the MicrosoftMicrosoft Connector for Oracle by Attunity. MicrosoftMicrosoft Connector for Oracle by Attunity 还包括连接管理器和源。The MicrosoftMicrosoft Connector for Oracle by Attunity also includes a connection manager and a source. 有关详细信息,请访问下载页 Microsoft Connectors for Oracle and Teradata by AttunityFor more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.
SAP BI 目标SAP BI Destination SAP BI 目标是 MicrosoftMicrosoft Connector for SAP BI 的目标组件。The SAP BI destination is the destination component of the MicrosoftMicrosoft Connector for SAP BI. MicrosoftMicrosoft Connector for SAP BI 还包括连接管理器和源。The MicrosoftMicrosoft Connector for SAP BI also includes a connection manager and a source. 有关详细信息,请访问下载页 Microsoft SQL Server 功能包For more information, see the download page, Microsoft SQL Server Feature Pack.
Teradata 目标Teradata Destination Teradata 目标是 MicrosoftMicrosoft Connector for Teradata by Attunity 的目标组件。The Teradata destination is the destination component of the MicrosoftMicrosoft Connector for Teradata by Attunity. MicrosoftMicrosoft Connector for Teradata by Attunity 还包括连接管理器和源。The MicrosoftMicrosoft Connector for Teradata by Attunity also includes a connection manager and a source. 有关详细信息,请访问下载页 Microsoft Connectors for Oracle 和 Teradata by AttunityFor more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

有关如何利用 MicrosoftMicrosoft Connector for Oracle by Attunity 提高性能的演示,请参阅 Microsoft Connector for Oracle by Attunity 的性能(SQL Server 视频)For a demonstration on how to leverage the performance gains of the MicrosoftMicrosoft Connector for Oracle by Attunity, see Performance of Microsoft Connector for Oracle by Attunity (SQL Server Video).

连接管理器Connection Managers

许多数据流组件都连接到数据源,因此,必须将组件所需的连接管理器添加到包,然后才能正确配置组件。Many data flow components connect to data sources, and you must add the connection managers that the components require to the package before the component can be configured correctly. 可以在构造数据流时或开始构造数据流之前添加连接管理器。You can add the connection managers as you construct the data flow, or before you start to construct the data flow. 有关详细信息,请参阅 Integration Services (SSIS) 连接创建连接管理器For more information, see Integration Services (SSIS) Connections and Create Connection Managers.

外部元数据External Metadata

使用 SSISSSIS 设计器在包中创建数据流时,源和目标的元数据被复制到源和目标的外部列,充当架构的快照。When you create a data flow in a package using SSISSSIS Designer, the metadata from the sources and destinations is copied to the external columns on sources and destinations, serving as a snapshot of the schema. Integration ServicesIntegration Services 验证包时, SSISSSIS 设计器将此快照与源或目标的架构比较,并根据更改发布错误和警告。When Integration ServicesIntegration Services validates the package, SSISSSIS Designer compares this snapshot against the schema of the source or destination, and posts errors and warnings, depending on the changes.

Integration ServicesIntegration Services 项目提供脱机模式。The Integration ServicesIntegration Services project provides an offline mode. 当您离线工作时,不会建立与包所使用的源或目标的连接,也不会更新外部列的元数据。When you work offline no connections are made to the sources or destinations the package uses, and the metadata of external columns is not updated.

输入和输出Inputs and Outputs

源有输出,目标有输入,而转换既有输入,又有输出。Sources have outputs, destinations have inputs, and transformations have both inputs and outputs. 此外,可将许多数据流组件配置为使用错误输出。Additionally, many data flow components can be configured to use an error output.

输入Inputs

目标和转换具有输入。Destinations and transformations have inputs. 输入包含一个或多个输入列,如果数据流组件已配置为使用外部列,则输入列可引用外部列。An input contains one or more input columns, which can refer to external columns if the data flow component has been configured to use them. 输入可配置为监视和控制数据流:例如,可指定在出现错误时组件是应失败、忽略错误,还是将错误行重定向至错误输出。Inputs can be configured to monitor and control the flow of data: For example, you can specify if the component should fail in response to an error, ignore errors, or redirect error rows to the error output. 还可为输入指派说明,或更新输入名称。You can also assign a description to the input or update the input name. SSISSSIS 设计器中,使用 “高级编辑器” 对话框对输入进行配置。In SSISSSIS Designer, inputs are configured by using the Advanced Editor dialog box. 有关 “高级编辑器” 的详细信息,请参阅 Integration Services User InterfaceFor more information about the Advanced Editor, see Integration Services User Interface.

输出Outputs

源和转换始终具有输出。Sources and transformations always have outputs. 输出包含一个或多个输出列,如果数据流组件已配置为使用外部列,则输出列可引用外部列。An output contains one or more output columns, which can refer to external columns if the data flow component has been configured to use them. 可对输出进行配置以提供对数据的下游处理有用的信息。Outputs can be configured to provide information useful to downstream processing of the data. 例如,可指示输出是否已排序。For example, you can indicate whether the output is sorted. 还可为输出提供说明或更新输出名称。You can also provide a description for the output, or update the output name. SSISSSIS 设计器中,使用 “高级编辑器” 对话框对输出进行配置。In SSISSSIS Designer, outputs are configured by using the Advanced Editor dialog box.

错误输出Error Outputs

源、目标和转换都可包含错误输出。Sources, destinations, and transformations can include error outputs. 可使用 “配置错误输出” 对话框指定数据流组件响应每个输入中错误或列中错误的方式。You can specify how the data flow component responds to errors in each input or column by using the Configure Error Output dialog box. 如果错误或数据截断在运行时发生,且将数据流组件配置为重定向行,则有错误的数据行将被发送到错误输出。If an error or data truncation occurs at run time and the data flow component is configured to redirect rows, the data rows with the error are sent to the error output. 可以将错误输出连接到转换,这些转换应用其他转换或将数据定向到其他目标。The error output can be connected to transformations that apply additional transformations or direct data to a different destination. 默认情况下,错误输出包含输出列和两个错误列:ErrorCode 和 ErrorColumn 。By default, an error output contains the output columns and two error columns: ErrorCode and ErrorColumn. 输出列包含失败行的数据, ErrorCode 提供错误代码,而 ErrorColumn 标识失败的列。The output columns contain the data from the row that failed, ErrorCode provides the error code, and ErrorColumn identifies the failing column.

有关详细信息,请参阅 数据中的错误处理For more information, see Error Handling in Data.

“列”Columns

输入、输出和错误输出是列的集合。Inputs, outputs, and error outputs are collections of columns. 每一列都可配置并且根据列类型(输入、输出或外部),Integration ServicesIntegration Services 会为列提供不同的属性。Each column is configurable and depending on the column type-input, output, or external- Integration ServicesIntegration Services provides different properties for the column. Integration ServicesIntegration Services 提供 3 种不同的列属性设置方法:编程方式、使用组件特定对话框,或使用“高级编辑器” 对话框。provides three different ways of setting column properties: programmatically, by using component-specific dialog boxes, or by using the Advanced Editor dialog box.

路径Paths

路径连接数据流组件。Paths connect data flow components. SSISSSIS 设计器中,可以查看和修改路径属性,查看路径开始点的输出元数据,以及将数据查看器附加到路径。In SSISSSIS Designer, you can view and modify the path properties, view the output metadata for the path start point, and attach data viewers to a path.

有关详细信息,请参阅 Integration Services PathsDebugging Data FlowFor more information, see Integration Services Paths and Debugging Data Flow.

配置数据流组件Configuration of Data Flow Components

数据流组件可在下列级别配置:组件级;输入级、输出级和错误输出级;列级。Data flow components can be configured at the component level; at the input, output, and error output levels; and at the column level.

  • 在组件级,设置对所有组件都通用的属性,并设置组件的自定义属性。At the component level, you set properties that are common to all components, and you set the custom properties of the component.

  • 在输入级、输出级和错误输出级,设置输入、输出和错误输出的公用属性。At the input, output, and error output levels, you set the common properties of inputs, outputs, and the error output. 如果组件支持多个输出,可添加输出。If the component supports multiple outputs, you can add outputs.

  • 在列级,除了组件为列提供的任何自定义属性之外,还可以设置所有列共有的属性。At the column level, you set the properties that are common to all columns, in addition to any custom properties that the component provides for columns. 如果组件支持添加输出列,则可向输出添加列。If the component supports the addition of output columns, you can add columns to outputs.

可以通过 SSISSSIS 设计器或以编程方式来设置属性。You can set properties through SSISSSIS Designer or programmatically. SSISSSIS 设计器中,您可以使用为每个元素类型提供的自定义对话框,或者使用“属性”窗口或 “高级编辑器” 对话框来设置元素属性。In SSISSSIS Designer, you can set element properties using the custom dialog boxes provided for each element type, or by using the Properties window or the Advanced Editor dialog box.

有关如何使用 SSISSSIS 设计器设置属性的详细信息,请参阅 设置数据流组件的属性For more information about how to set properties by using SSISSSIS Designer, see Set the Properties of a Data Flow Component.

在数据流中添加或删除组件Add or Delete a Component in a Data Flow

连接数据流中的组件Connect Components in a Data Flow

technet.microsoft.com 上的视频 Microsoft Connector for Oracle by Attunity 的性能(SQL Server 视频)Video, Performance of Microsoft Connector for Oracle by Attunity (SQL Server Video), on technet.microsoft.com.