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