Integration Services Connections
Microsoft SQL Server 2005 Integration Services (SSIS) packages use connections to perform different tasks and to implement Integration Services features.
- Connecting to source and destination data stores such as text, XML, Excel workbooks, and relational databases to extract and load data.
- Connecting to relational databases that contain reference data to perform exact or fuzzy lookups.
- Connecting to relational databases to run SQL statements such as SELECT, DELETE, and INSERT commands and also stored procedures.
- Connecting to SQL Server to perform maintenance and transfer tasks such as backing up databases and transferring logins.
- Writing log entries in text and XML files and SQL Server 2005 tables and package configurations to SQL Server 2005 tables.
- Connecting to SQL Server to create temporary work tables that some transformations require to do their work.
- Connecting to Analysis Services projects and databases to access data mining models, process cubes and dimensions, and run DDL code.
- Specifying existing or creating new files and folders to use with Foreach Loop enumerators and tasks.
- Connecting to message queues and to Windows Management Instrumentation (WMI), SQL Server Management Objects (SMO), Web, and mail servers.
In This Section
The following table lists topics in this section.
| Topic | Description |
|---|---|
Describes how connection managers work. |
|
Describes the connection manager for connecting to relational data sources by using ADO. |
|
Describes the connection manager for connecting to relational data sources by using ADO.NET. |
|
Describes the Microsoft .NET Data Provider for mySAP Business Suite, for accessing SAP data. |
|
Describes the connection manager for connecting to an instance of Analysis Services or an Analysis Services project. |
|
Describes the connection manager for connecting to Excel workbooks. |
|
Describes the connection manager for connecting to a single file or folder. |
|
Describes the connection manager for accessing data in a single flat file. |
|
Describes the connection manager for connecting to an FTP server. |
|
Describes the connection manager for connecting to a Web service or Web site. |
|
Describes the connection manager for connecting to a Message Queuing (also known as MSMQ) message queue. |
|
Describes the connection manager for connecting to multiple files and folders. |
|
Describes the connection manager for accessing data in multiple flat files. |
|
Describes the connection manager for connecting to data sources by using ODBC. |
|
Describes the connection manager for connecting to data sources by using OLE DB. |
|
Describes the connection manager for connecting to SQL Server Management Objects (SMO). |
|
Describes the connection manager for connecting to SMTP servers. |
|
Describes the connection manager for connecting to SQL Server 2005 Compact Edition databases. |
|
Describes the connection manager for connecting to a Windows Management Instrumentation (WMI) server and specifying a server namespace. |
|
Describes the data source object from which you can create a connection manager. |
|
Describes a view that you create based on a data source. |
See Also
Other Resources
Integration Services Objects and Concepts