The XML connector is an object that is used to get data from XML files (*.xml).
After adding the connector to the ETL task workspace, set basic properties and import options. The connector output can also be edited and data filtering options can also be set.
The Import Options page is used to specify a file with imported data and parameters used to determine data range.
Specify path to XML file to be used as a data provider. Click the Browse button to select a file.
Enter text of the query, based on which data is to be selected, in the Query for Output Nodes box.
NOTE. The query format depends on the structure of the file in use. A detailed information on how to create XPath queries can be obtained in additional manuals, such as MSDN.
The File Format group includes radio buttons that define format of the input file:
Fields in Nodes. Fields are regarded as child nodes.
Fields in Attributes. Fields are regarded as attributes.
If the Request File on Task Execution checkbox is selected, the dialog box for selecting an XML file opens on executing an ETL task. The checkbox is deselected by default, working is executed with the file that is specified in the Source File box.
The Settings button enables the user to determine advanced settings used on identifying data.
The Browse Data button shows data selected by a query.
NOTE. Only the first hundred of the provider lines will be displayed during the data preview.
See also: