共用方式為


Extending Packages with Custom Objects

新增: 2005 年 12 月 5 日

If you find that the components provided in Integration Services do not meet your requirements, you can extend the power of Integration Services by coding your own extensions. You have two discrete options for extending your packages: you can write code within the powerful wrappers provided by the Script task and the Script component, or you can create custom Integration Services extensions from scratch by deriving from the base classes provided by the Integration Services object model.

This section explores the more advanced of the two options — extending packages with custom objects.

When your custom Integration Services solution requires more flexibility than the Script task and the Script component provide, or when you need a component that you can reuse in multiple packages, the Integration Services object model lets you build custom tasks, data flow components, and other package objects in managed code from the ground up.

在此章節中

Topic Description

Developing Custom Objects for Integration Services

Discusses the custom objects that can be created for Integration Services, and summarizes the essential steps and settings.

Persisting Custom Objects

Discusses the default persistence of custom objects, and the process of implementing custom persistence.

Building, Deploying, and Debugging Custom Objects

Discusses the common approaches to building, deploying and testing the various types of custom objects.

Creating a Custom Task

Describes the process of coding a custom task.

Creating a Custom Connection Manager

Describes the process of coding a custom connection manager.

Creating a Custom Log Provider

Describes the process of coding a custom log provider.

Creating a Custom Foreach Enumerator

Describes the process of coding a custom enumerator.

Developing a Custom Data Flow Component

Discusses how to program custom data flow sources, transformations, and destinations.

參考

Topic Description

Integration Services Error and Message Reference

Lists the predefined Integration Services error codes with their symbolic names and descriptions.

相關章節

Topic Description

Integration Services Programming

Introduces Integration Services programming concepts.

Extending Packages with Scripting

Discusses how to extend the control flow by using the Script task, or extend the data flow by using the Script component.

Building Packages Programmatically

Describes how to create, configure, run, load, save, and manage Integration Services packages programmatically.

程式設計範例

Lists and describes the Integration Services programming samples that are available as an optional installation component.

請參閱

參考

Comparing Scripting Solutions and Custom Objects

概念

Integration Services Programming

其他資源

SQL Server Integration Services
Integration Services 開發人員資訊中心
Integration Services 開發的增強功能

說明及資訊

取得 SQL Server 2005 協助