Share via


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

Connection Managers

Describes how connection managers work.

ADO Connection Manager

Describes the connection manager for connecting to relational data sources by using ADO.

ADO.NET Connection Manager

Describes the connection manager for connecting to relational data sources by using ADO.NET.

Microsoft .NET Data Provider for mySAP Business Suite

Describes the Microsoft .NET Data Provider for mySAP Business Suite, for accessing SAP data.

Analysis Services Connection Manager

Describes the connection manager for connecting to an instance of Analysis Services or an Analysis Services project.

Excel Connection Manager

Describes the connection manager for connecting to Excel workbooks.

File Connection Manager

Describes the connection manager for connecting to a single file or folder.

Flat File Connection Manager

Describes the connection manager for accessing data in a single flat file.

FTP Connection Manager

Describes the connection manager for connecting to an FTP server.

HTTP Connection Manager

Describes the connection manager for connecting to a Web service or Web site.

MSMQ Connection Manager

Describes the connection manager for connecting to a Message Queuing (also known as MSMQ) message queue.

Multiple Files Connection Manager

Describes the connection manager for connecting to multiple files and folders.

Multiple Flat Files Connection Manager

Describes the connection manager for accessing data in multiple flat files.

ODBC Connection Manager

Describes the connection manager for connecting to data sources by using ODBC.

OLE DB Connection Manager

Describes the connection manager for connecting to data sources by using OLE DB.

SMO Connection Manager

Describes the connection manager for connecting to SQL Server Management Objects (SMO).

SMTP Connection Manager

Describes the connection manager for connecting to SMTP servers.

SQL Server Compact Edition Connection Manager

Describes the connection manager for connecting to SQL Server 2005 Compact Edition databases.

WMI Connection Manager

Describes the connection manager for connecting to a Windows Management Instrumentation (WMI) server and specifying a server namespace.

Data Source (SSIS)

Describes the data source object from which you can create a connection manager.

Data Source View (SSIS)

Describes a view that you create based on a data source.

See Also

Other Resources

Integration Services Objects and Concepts

Help and Information

Getting SQL Server 2005 Assistance