Updating destination list failed
Click Preview to view up to 200 rows of data for the table that you selected.
Use the Mappings page of the ODBC Destination Editor dialog box to map input columns to destination columns. Drag-and-drop an input column to an available destination column to map the columns. Drag-and-drop a destination column to an available input column to map the columns. You can remove mappings by selecting to exclude columns from the output.
The SSIS developer must be aware of the limitations of any ODBC provider being used and take them into consideration when building SSIS packages.
The two modes are: There is no limitation on the number of ODBC destination components that can run in parallel against the same table or different tables, on the same machine or on different machines (other than normal global session limits).
However, limitations of the ODBC provider being used may restrict the number of concurrent connections through the provider.
An ODBC destination includes mappings between input columns and columns in the destination data source.
You do not have to map input columns to all destination columns, but depending on the properties of the destination columns, errors may occur if no input columns are mapped to the destination columns.