Export (0) Print
Expand All
0 out of 5 rated this helpful - Rate this topic

ODBC Connection Manager

An ODBC connection manager enables a package to connect to a variety of database management systems using the Open Database Connectivity specification (ODBC).

When you add an ODBC connection to a package and set the connection manager properties, SQL Server 2005 Integration Services (SSIS) creates a connection manager and adds the connection manager to the Connections collection of the package. At run time the connection manager is resolved as a physical ODBC connection.

The ConnectionManagerType property of the connection manager is set to ODBC.

You can configure the ODBC connection manager in the following ways:

  • Provide a connection string that references a user or system data source name.
  • Specify the server to connect to.
  • Indicate whether the connection is retained at run time.

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in SSIS Designer, click one of the following topics:

For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.