Share via

ODBC Destination Editor (Connection Manager Page)

  • Article

Use the Connection Manager page of the ODBC Destination Editor dialog box to select the ODBC connection manager for the destination. This page also lets you select a table or view from the database

For more information about the ODBC destination, see ODBC Destination.

To open the ODBC Destination Editor Connection Manager Page

  • In SQL Server Data Tools, open the SQL Server 2012 Integration Services (SSIS) package that has the ODBC destination.

  • On the Data Flow tab, double-click the ODBC destination.

  • In the ODBC Destination Editor, click Connection Manager.

Options

Connection manager

Select an existing ODBC connection manager from the list, or click New to create a new connection. The connection can be to any ODBC-supported database.

New

Click New. The Configure ODBC Connection Manager Editor dialog box opens where you can create a new connection manager.

Data Access Mode

Select the method for loading data to the destination. The options are shown in the following table:

Option

Description

Table Name - Batch

Select this option to configure the ODBC destination to work in batch mode. When you select this option the following options are available:

  • Name of the table or the view: Select an available table or view from the list.

  • This list contains the first 1000 tables only. If your database contains more than 1000 tables, you can type the beginning of a table name or use the (*) wild card to enter any part of the name to display the table or tables you want to use.

  • Batch size: Type the size of the batch for bulk loading. This is the number of rows loaded as a batch

Table Name - Row by Row

Select this option to configure the ODBC destination to insert each of the rows into the destination table one at a time. When you select this option the following option is available:

  • Name of the table or the view: Select an available table or view from the database from the list.

  • This list contains the first 1000 tables only. If your database contains more than 1000 tables, you can type the beginning of a table name or use the (*) wild card to enter any part of the name to display the table or tables you want to use.

Preview

Click Preview to view up to 200 rows of data for the table that you selected.

See Also

Reference

ODBC Destination Editor (Mappings Page)

ODBC Destination Editor (Error Output Page)

Concepts

ODBC Destination Custom Properties