Developing a Custom Connection Manager
Applies To: SQL Server 2016 Preview
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.
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.
Creating a Custom Connection Manager
Describes how to create the classes for a custom connection manager project.
Coding a Custom Connection Manager
Describes how to implement a custom connection manager by overriding the methods and properties of the base class.
Developing a User Interface for a Custom Connection Manager
Describes how to implement the user interface class and the form that is used to configure the custom connection manager.
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 types 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 on the other types of custom objects that you can create in Integration Services, see the following topics:
Developing a Custom Task
Discusses how to program custom tasks.
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.
| 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:
Visit the Integration Services page on MSDN
For automatic notification of these updates, subscribe to the RSS feeds available on the page.