| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Extending Packages with Custom Objects |
Extending Packages with Custom Objects |
chugugrace |
chugu |
03/06/2017 |
sql |
integration-services |
reference |
[!INCLUDEsqlserver-ssis]
If you find that the components provided in [!INCLUDEssISnoversion] do not meet your requirements, you can extend the power of [!INCLUDEssISnoversion] 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 [!INCLUDEssISnoversion] extensions from scratch by deriving from the base classes provided by the [!INCLUDEssISnoversion] object model.
This section explores the more advanced of the two options - extending packages with custom objects.
When your custom [!INCLUDEssISnoversion] 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 [!INCLUDEssISnoversion] object model lets you build custom tasks, data flow components, and other package objects in managed code from the ground up.
Developing Custom Objects for Integration Services
Discusses the custom objects that can be created for [!INCLUDEssISnoversion], 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.
Developing a Custom Task
Describes the process of coding a custom task.
Developing a Custom Connection Manager
Describes the process of coding a custom connection manager.
Developing a Custom Log Provider
Describes the process of coding a custom log provider.
Developing 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.
Integration Services Error and Message Reference
Lists the predefined [!INCLUDEssISnoversion] error codes with their symbolic names and descriptions.
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 [!INCLUDEssISnoversion] packages programmatically.
Comparing Scripting Solutions and Custom Objects
SQL Server Integration Services