ssis组件_SSIS脚本组件概述

ssis组件

SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties.

SSIS脚本组件是SQL Server集成服务的突出优势，因为它允许开发人员实现任何复杂的逻辑并利用功能强大的.NET框架或第三方提供的库。

In this article, we will give an overview of SSIS Script component, and illustrate the benefits of using it. In addition, we will answer some of the most common questions asked concerning writing scripts in SSIS, such as the difference between a derived column transformation and a Script component.

在本文中，我们将概述SSIS脚本组件，并说明使用它的好处。 另外，我们将回答一些有关在SSIS中编写脚本的常见问题，例如派生列转换和Script组件之间的区别。

SSIS Script component can be used in three ways:

SSIS脚本组件可以三种方式使用：

1. As a source component
   作为源组件
2. As a destination component
   作为目标组件
3. As a transformation component
   作为转换组件

When adding a Script component to the data flow task, you will be asked how the script will be used, as shown in the image below:

将脚本组件添加到数据流任务时，将询问您如何使用脚本，如下图所示：

SSIS脚本组件编辑器 (SSIS Script component editor)

Before describing each approach, we will illustrate the options that can be configured in the SSIS script component editor. If you open the SSIS Script component editor, you will see four tabs:

在介绍每种方法之前，我们将说明可以在SSIS脚本组件编辑器中配置的选项。 如果打开SSIS脚本组件编辑器，将看到四个选项卡：

• Script: Here, you can open the script editor where you can write your script, select the script programming language (C# or VB.NET) and select the SSIS variables you need within the script (for read or write purposes) 脚本：在这里，您可以打开脚本编辑器，在其中编写脚本，选择脚本编程语言（C＃或VB.NET），然后在脚本中选择所需的SSIS变量（用于读取或写入）
• Input Columns: Here, you can select the input columns for use within the script 输入列：在这里，您可以选择脚本中要使用的输入列
• Inputs and Outputs: Here, you can configure the outputs generated by the script (number of outputs, type of each output, output columns, etc.) 输入和输出：在这里，您可以配置脚本生成的输出（输出数量，每个输出的类型，输出列等）
• Connection Managers: Here, you can select the connection managers for use within the script 连接管理器：在这里，您可以选择要在脚本中使用的连接管理器

Note, that when using the SSIS script component as a source, there are no input columns to select. In addition, whe