SQL Destination Editor (Mappings Page)

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

To learn more about the SQL Server destination, see SQL Server Destination.

Options

• 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 input columns selected from the table above. You can change the mappings by using the list of Available Input Columns.

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

See Also

Tasks

How to: Bulk Load Data by Using the SQL Server Destination

Reference

SQL Destination Editor (Connection Manager Page)

SQL Destination Editor (Advanced Page)

Concepts

Integration Services Error and Message Reference