ODBC Source Editor (Columns Page)
Use the Columns page of the ODBC Source Editor dialog box to map an output column to each external (source) column.
To learn more about the ODBC source, see ODBC Source.
Task List
To open the ODBC Source Editor Columns 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.
In the ODBC Source Editor, click Columns.
Options
Available External Columns
A list of available external columns in the data source. You cannot use this table to add or delete columns. Select the columns to use from the source. The selected columns are added to the External Column list in the order they are selected.
Select the Select All check box to select all of the columns.
External Column
A view of the external (source) columns in the order that you see them when configuring components that consume data from the ODBC source.
Output Column
Enter a unique name for each output column. The default is the name of the selected external (source) column; however, you can choose any unique, descriptive name. The name entered is displayed in the SSIS Designer.
See Also
ODBC Source Editor (Connection Manager Page)
ODBC Source Editor (Error Output Page)