XML Input Format Parameters

The XML input format supports the following parameters:

rootXPath
  Values: XPath query
  Default: not specified
  Description: XPath query of document node(s) to be considered root node(s).
  Details: The node(s) selected by the specified XPath replace the document root node as the starting node(s) from which all the document nodes are visited.

Note: This parameter is ignored for XML documents whose filename or URL has been specified together with an optional XPath in the from-entity.

Note: The XPath specified for this parameter is case-sensitive. If an XPath is specified containing non-existing node or attribute names, or containing node or attribute names with the wrong capitalization, no root node is selected and an error is returned.

  Example: -rootXPath:/World/Continent/Country
 
fMode
  Values: Branch | Tree | Node | Auto
  Default: Auto
  Description: Algorithm to use when visiting the document nodes.
  Details: For information on the "Branch", "Tree", and "Node" visit algorithms see XML Input Format Fields.
The "Auto" value instructs the XML input format to determine automatically the best algorithm after inspecting the structure of the input document(s).
  Example: -fMode:Tree
 
iTsFormat
  Values: timestamp format
  Default: yyyy-MM-dd?hh:mm:ss
  Description: Format of timestamp values in the document.
  Details: This parameter specifies the date and/or time format used in the document being parsed. Values of nodes or attributes matching the specified format are returned as values of the TIMESTAMP data type. For more information on date and time formats, see Timestamp Format Specifiers.
  Example: -iTsFormat:"MMM dd, yyyy"
 
dtNodes
  Values: number of leaf nodes (number)
  Default: -1
  Description: Number of leaf nodes to be examined when determining the document structure.
  Details: In order to determine the input document structure, the XML input format initially examines the nodes found along the paths from the root node or from the node(s) selected by the user-supplied root XPath to the first n leaf nodes, where n is the value specified for this parameter.
Specifying -1 causes the XML input format to examine all the nodes in the input document.
  Example: -dtNodes:50
 
fNames
  Values: Compact | XPath
  Default: Compact
  Description: Field naming schema.
  Details: Specifying "Compact" causes the XML input format to create field names using the names of the corresponding nodes or attributes. If a field name is not unique, a sequential number is appended to the name to render it unique.
Example field names in the "Compact" mode are:
ContinentName
CountryName
City
Population
Specifying "XPath" causes the XML input format to create field names using the XPath queries for the corresponding nodes or attributes.
Example field names in the "XPath" mode are:
/World/Continent/@ContinentName
/World/Continent/Country/@CountryName
/World/Continent/Country/City
/World/Continent/Country/City/@Population
  Example: -fNames:XPath
 

© 2004 Microsoft Corporation. All rights reserved.