Bagikan melalui


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 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.

For working samples of custom tasks, see the the Integration Services samples on Codeplex.

In This Section

This section describes how to create, configure, and code a custom task and its optional custom user interface.

Information Common to all Custom Objects

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

Information about Other Custom Objects

For information about the other types of custom objects that you can create in Integration Services, see the following topics:

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 or TechNet:

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