XML Source Editor (Columns Page)

Use the Columns node of the XML Source Editor dialog box to map an output column to an external (source) column.

For more information about the XML source, see XML Source.

Options

  • Available External Columns
    View the list of available external columns in the data source. You cannot use this table to add or delete columns.
  • External Column
    View external (source) columns in the order in which the task will read them. You can change this order by first clearing the selected columns in the table displayed in the editor, and then selecting external columns from the list in a different order.
  • Output Column
    Provide 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 provided will be displayed within SSIS Designer.

See Also

Reference

XML Source Editor (Connection Manager Page)
XML Source Editor (Error Output Page)

Other Resources

Integration Services Error and Message Reference
How to: Extract Data Using the XML Source

Help and Information

Getting SQL Server 2005 Assistance