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: Using 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
Reference
XML Source Editor (Columns Page)
XML Source Editor (Error Output Page)
Other Resources
Integration Services Error and Message Reference
How to: Extract Data Using the XML Source