Share via


Developing a Custom Connection Manager

Integration Services uses connection managers to encapsulate the information needed to connect to an external data source. Integration Services includes a variety of connection managers that support connections to the most commonly used data sources, from enterprise databases to text files and Excel worksheets. If the connection managers and external data sources supported by Integration Services do not entirely meet your requirements, you can create a custom connection manager.

To create a custom connection manager, you have to create a class that inherits from the ConnectionManagerBase base class, apply the DtsConnectionAttribute attribute to your new class, and override the important methods and properties of the base class, including the ConnectionString property and the AcquireConnection method.

Important

Most of the tasks, sources, and destinations that have been built into Integration Services work only with specific types of built-in connection managers. Before developing a custom connection manager for use with built-in tasks and components, check whether those components restrict the list of available connection managers to those of a specific type. If your solution requires a custom connection manager, you might also have to develop a custom task, or a custom source or destination, for use with the connection manager.

In This Section

This section describes how to create, configure, and code a custom connection manager and its optional custom user interface. The code snippets shown in this section are drawn from the Sql Server Custom Connection Manager Sample.

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 on 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:


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