Connection Manager How-to Topics (Integration Services)

This section contains procedures for working with connection managers by using the Integration Services tools that Business Intelligence Development Studio provides.

How to: Add or Delete a Connection Manager in a Package

How to: Use a Data Source in a Package

How to: Set the Properties of a Connection Manager

How to: Use a Data Source View in a Package

How to: Connect to a dBASE or Other DBF File

How to: Connect to an Access Database

How to: Connect to an Excel Workbook

The properties of connection managers such as the connection string must frequently be updated at run time. To learn more about dynamically updating properties, see Package Configurations and Using Property Expressions in Packages.

Integration Services icon (small) 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 or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions