XML Source Editor (Connection Manager Page)

Use the Connection Manager page of the XML Source Editor to specify an XML file and the XSD that transforms the XML data.

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

Static Options

Data access mode
Specify the method for selecting data from the source.

Value Description
XML file location Retrieve data from an XML file.
XML file from variable Specify the XML file name in a variable.

Related information: Use Variables in Packages
XML data from variable Retrieve XML data from a variable.

Use inline schema
Specify whether the XML source data itself contains the XSD schema that defines and validates its structure and data.

XSD location
Type the path and file name of the XSD schema file, or locate the file by clicking Browse.

Browse
Use the Open dialog box to locate the XSD schema file.

Generate XSD
Use the Save As dialog box to select a location for the auto-generated XSD schema file. The editor infers the schema from the structure of the XML data.

Data Access Mode Dynamic Options

Data access mode = XML file location

XML location
Type the path and file name of the XML data file, or locate the file by clicking Browse.

Browse
Use the Open dialog box to locate the XML data file.

Data access mode = XML file from variable

Variable name
Select the variable that contains the path and file name of the XML file.

Data access mode = XML data from variable

Variable name
Select the variable that contains the XML data.

See Also

Integration Services Error and Message Reference
XML Source Editor (Columns Page)
XML Source Editor (Error Output Page)
Extract Data by Using the XML Source