TechNet
Export (0) Print
Expand All

ADO NET Destination Editor (Mappings Page)

 

Applies To: SQL Server 2016

Use the Mappings page of the ADO NET Destination Editor dialog box to map input columns to destination columns.

To learn more about the ADO NET destination, see ADO NET Destination.

To open the Mappings page

  1. In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET destination.

  2. On the Data Flow tab, double-click the ADO NET destination.

  3. In the ADO NET Destination Editor, click Mappings.

Available Input Columns
View the list of available input columns. Use a drag-and-drop operation to map available input columns in the table to destination columns.

Available Destination Columns
View the list of available destination columns. Use a drag-and-drop operation to map available destination columns in the table to input columns.

Input Column
View the input columns that you selected. You can remove mappings by selecting <ignore> to exclude columns from the output.

Destination Column
View each available destination column, regardless of whether it is mapped or not.

ADO NET Destination Editor (Connection Manager Page)
ADO NET Destination Editor (Error Output Page)

Community Additions

ADD
Show:
© 2016 Microsoft