Share via


Excel Destination Editor (Mappings Page)

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

To learn more about the Excel destination, see Excel 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

Reference

Excel Destination Editor (Connection Manager Page)
Excel Destination Editor (Error Output Page)

Other Resources

Integration Services Error and Message Reference
How to: Loop through Excel Files and Tables

Help and Information

Getting SQL Server 2005 Assistance