The XML source reads an XML data file and populates the columns in the source output with the data.
The XML source uses a schema to interpret the XML data. The XML source supports using an XML Schema Definition (XSD) file or inline schemas to translate the XML data into a tabular format.
The XML Source Editor dialog uses the specified schema to generate the XML source outputs.
The XML source supports three different data access modes. You can specify the XML data file's file location, the variable that contains the file location, or the variable that contains the XML data.
Use the Connection Manager page of the XML Source Editor to specify an XML file and the XSD that transforms the XML data.
You can specify any of the following methods for selecting data from the source as Data access mode.
|XML file location
|Retrieve data from an XML file.
|XML file from variable
|Specify the XML file name in a variable.
|XML data from variable
|Retrieve XML data from a variable.
The XML source has both custom properties and properties common to all data flow components.
The following table describes the custom properties of the XML source. All properties are read/write.
|The mode used to access the XML data.
|A value that indicates whether to use an inline schema definition within the XML source. The default value of this property is False.
|The file or variables from which to retrieve the XML data. The value of this property can be specified by using a property expression.
|The path and file name of the schema definition file (.xsd).
The value of this property can be specified by using a property expression.
The following table describes the custom properties of the output of the XML source. All properties are read/write.
|A value that identifies the rowset associated with the output.
The output columns of the XML source have no custom properties.