Connection Managers
A connection manager is a logical representation of a connection. At design time, you set the properties of a connection manager to describe the physical connection that Integration Services creates when the package runs. For example, a connection manager includes the ConnectionString property that you set at design time; at run time, a physical connection is created using the value in the connection string property.
A package can use multiple instances of a connection manager type, and you can set the properties on each instance. At run time, each instance of a connection manager type creates a connection that has different attributes.
SQL Server 2005 Integration Services (SSIS) provides different types of connection managers that enable packages to connect to a variety of data sources and servers.
The following table lists the connection manager types.
| Type | Description | Topic |
|---|---|---|
ADO |
Connects to ActiveX Data Objects (ADO) objects. |
|
ADO.NET |
Connects to a data source by using a .NET provider. |
|
EXCEL |
Connects to an Excel workbook file. |
|
FILE |
Connects to a file or a folder. |
|
FLATFILE |
Connect to data in a single flat file. |
|
FTP |
Connect to an FTP server. |
|
HTTP |
Connects to a web server. |
|
MSMQ |
Connects to a message queue. |
|
MSOLAP90 |
Connects to an instance of SQL Server 2005 Analysis Services (SSAS) or an Analysis Services project. |
|
MULTIFILE |
Connects to multiple files and folders. |
|
MULTIFLATFILE |
Connects to multiple data files and folders. |
|
OLEDB |
Connects to a data source by using an OLE DB provider. |
|
ODBC |
Connects to a data source by using ODBC. |
|
SMOServer |
Connects to a SQL Server Management Objects (SMO) server. |
|
SMTP |
Connects to an SMTP mail server. |
|
SQLMOBILE |
Connects to a SQL Server 2005 Compact Edition database. |
|
WMI |
Connects to a server and specifies the scope of Windows Management Instrumentation (WMI) management on the server. |
See Also
Other Resources
Integration Services Connections