Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Developing a Custom Task


Integration Services uses tasks to perform units of work in support of the extraction, transformation, and loading of data. Integration Services 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.

To create a custom task, you have to create a class that inherits from the T:Microsoft.SqlServer.Dts.Runtime.Task base class, apply the T:Microsoft.SqlServer.Dts.Runtime.DtsTaskAttribute attribute to your new class, and override the important methods and properties of the base class, including the M:Microsoft.SqlServer.Dts.Runtime.Task.Execute(Microsoft.SqlServer.Dts.Runtime.Connections,Microsoft.SqlServer.Dts.Runtime.VariableDispenser,Microsoft.SqlServer.Dts.Runtime.IDTSComponentEvents,Microsoft.SqlServer.Dts.Runtime.IDTSLogging,System.Object) method.

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

Describes how to create a user interface that shows in SSIS Designer to configure properties on the custom task.

For information that is common to all the type of custom objects that you can create in Integration Services, see the following topics:

Developing Custom Objects for Integration Services

Describes the basic steps in implementing all kinds of custom objects for Integration 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.

For information about the other types of custom objects that you can create in Integration 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.

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 icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

© 2015 Microsoft