开发自定义任务Developing a Custom Task

Integration ServicesIntegration Services使用任务执行工作单元,从而支持数据的提取、转换和加载。uses tasks to perform units of work in support of the extraction, transformation, and loading of data. Integration ServicesIntegration Services 包含多种任务,这些任务可执行从执行 SQL 语句到从 FTP 站点下载文件的大部分常用操作。includes a variety of tasks that perform the most frequently used actions, from executing an SQL statement to downloading a file from an FTP site. 如果包含的任务和支持的操作不能完全满足您的要求,您可以创建自定义任务。If the included tasks and supported actions do not completely meet your requirements, you can create a custom task.

若要创建自定义任务,必须创建从 Task 基类继承的类,再将 DtsTaskAttribute 属性应用到新类,然后重写基类的重要方法和属性,包括 Execute 方法。To create a custom task, you have to create a class that inherits from the Task base class, apply the DtsTaskAttribute attribute to your new class, and override the important methods and properties of the base class, including the Execute method.

本节内容In This Section

本节介绍如何创建、配置和编写自定义任务及其可选自定义用户界面的代码。This section describes how to create, configure, and code a custom task and its optional custom user interface.

创建自定义任务Creating a Custom Task
介绍第一个步骤,即创建自定义任务。Describes the first step, which is creating the custom task.

编写自定义任务代码Coding a Custom Task
介绍如何编写自定义任务的主要方法的代码。Describes how to code the principal methods of a custom task.

在自定义任务中连接数据源Connecting to Data Sources in a Custom Task
介绍如何将自定义任务连接到数据源。Describes how to connect a custom task to a data source.

在自定义任务中引发和定义事件Raising and Defining Events in a Custom Task
介绍如何从自定义任务引发事件和定义自定义事件。Describes how to raise events and define custom events from the custom task.

在自定义任务中添加对调试的支持Adding Support for Debugging in a Custom Task
介绍如何在自定义任务中创建断点目标。Describes how to create breakpoint targets in the custom task.

为自定义任务开发用户界面Developing a User Interface for a Custom Task
介绍如何创建显示在 SSISSSIS 设计器中用于配置自定义任务属性的用户界面。Describes how to create a user interface that shows in SSISSSIS Designer to configure properties on the custom task.

所有自定义对象的通用信息Information Common to all Custom Objects

有关可以在 Integration ServicesIntegration Services 中创建的所有类型自定义对象的通用信息,请参阅以下主题:For information that is common to all the type of custom objects that you can create in Integration ServicesIntegration Services, see the following topics:

开发 Integration Services 的自定义对象Developing Custom Objects for Integration Services
介绍实现 Integration ServicesIntegration Services 的所有类型自定义对象的基本步骤。Describes the basic steps in implementing all kinds of custom objects for Integration ServicesIntegration Services.

使自定义对象持久化Persisting Custom Objects
介绍自定义持久性并在必要时作出解释。Describes custom persistence and explains when it is necessary.

生成、部署和调试自定义对象Building, Deploying, and Debugging Custom Objects
介绍生成、签名、部署和调试自定义对象的技术。Describes the techniques for building, signing, deploying, and debugging custom objects.

其他自定义对象的信息Information about Other Custom Objects

有关可以在 Integration ServicesIntegration Services 中创建的其他类型自定义对象的信息,请参阅以下主题:For information about the other types of custom objects that you can create in Integration ServicesIntegration Services, see the following topics:

开发自定义连接管理器Developing a Custom Connection Manager
讨论如何对自定义连接管理器进行编程。Discusses how to program custom connection managers.

开发自定义日志提供程序Developing a Custom Log Provider
讨论如何对自定义日志提供程序进行编程。Discusses how to program custom log providers.

开发自定义 ForEach 枚举器Developing a Custom ForEach Enumerator
讨论如何对自定义枚举器进行编程。Discusses how to program custom enumerators.

开发自定义数据流组件Developing a Custom Data Flow Component
讨论如何对自定义数据流源、转换和目标进行编程。Discusses how to program custom data flow sources, transformations, and destinations.

Integration Services 图标(小)保持与 Integration Services 最Integration Services icon (small) Stay Up to Date with Integration Services
若要从 Microsoft 获得最新的下载内容、文章、示例和视频,以及从社区获得所选解决方案,请访问 MSDN 上的 Integration ServicesIntegration Services 页:For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration ServicesIntegration Services page on MSDN:

访问 MSDN 上的 Integration Services 页Visit the Integration Services page on MSDN

若要获得有关这些更新的自动通知,请订阅该页上提供的 RSS 源。For automatic notification of these updates, subscribe to the RSS feeds available on the page.

另请参阅See Also

使用脚本任务扩展包 Extending the Package with the Script Task
比较脚本解决方案和自定义对象Comparing Scripting Solutions and Custom Objects