ODBC Source Editor (Connection Manager Page)
Use the Connection Manager page of the ODBC Source Editor dialog box to select the ODBC connection manager for the source. This page also lets you select a table or view from the database.
For more information about the ODBC source, see ODBC Source.
Task List
To open the ODBC Source Editor Connection Manager Page
In SQL Server Data Tools, open the SQL Server 2014 Integration Services (SSIS) package that has the ODBC source.
On the Data Flow tab, double-click the ODBC source.
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 ODBC connection manager.
Data Access Mode
Select the method for selecting data from the source. The options are shown in the following table:
| Option | Description |
|---|---|
| Table Name | Retrieve data from a table or view in the ODBC data source. When you select this option, select a value from the list for the following: |
| Name of the table or the view: Select an available table or view from the list or type a regular expression to identify the table. | |
| 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. | |
| SQL command | Retrieve data from the ODBC data source by using an SQL query. You should write the query in the syntax of the source database you are working with. When you select this option, enter a query in one of the following ways: |
| Enter the text of the SQL query in the SQL command text field. | |
| Click Browse to load the SQL query from a text file. | |
| Click Parse query to verify the syntax of the query text. |
Preview
Click Preview to view up to the first 200 rows of the data extracted from the table or view you selected.
See Also
ODBC Source Custom Properties
ODBC Source Editor (Columns Page)
ODBC Source Editor (Error Output Page)