Extracting data from XML file

[Remedy]

Hello guys !

I am new for the XML and need to access the data contents from the XML file.Is it possible to extract the data from the file.Is there any tools are available to access the data.If you have some solutions and compatible codes then please share with me.

Thanks.

[Reegan]

You can access the data from XML documents using the concept of XML Path (XPath) .A node is a complete element within an XML document.

For example, if you have an XML Document and coded with -

<customers>
<customer id="1">
<companyName>Oracle corp</companyName>
</customer>
<customer id="2">
<companyName>Microsoft</companyName>
</customer>
</customers>

A node could be
<companyName>Oracle corp</companyName>
or
Oracle corp
or
id="1"

[opaper]

if you are working with the windows application development tools then you can extract the data from the XML file using XML resources.In this scenario,you need to follow some steps-

1- Open the Integration Services project that includes the package you need.
2- From the Solution Explorer, double-click on the package and browse it.
3- Move to the Data Flow tab and click there now from the Toolbox, drag the XML source onto the design surface.
4- Make a Double click on the XML source.
5- From the XML Source Editor,select data access mode and set the following -

• XML file location
• XML file from variable
• XML data from variable

[MindSpace]

After selecting the XML file location,XML file from variable,XML data from variable file location and all ,you need to go further for advance changes to continue the steps -

• Select Use inline schema to locate that the XML document exist within schema information.
• To locate an external XML Schema definition language (XSD) schema for the XML file -

• Locate the existing XSD file.
• Create an XSD from the XML file.

• Click on the Columns and update the values in the Output Column listed.
• Now Click OK to save the changes.

[Modifier]

One more way to extract the data from XML document.The XML parser can be used to extract and use the data of the XML file.

The Implementation of the XML file would be as follows-

< GEN_FSM >

< State >

< Name >

POWERED

< /Name >

< Comment >

USB POWERED State

< /Comment >

< /State >

< State >

< Name >

DEFAULT

< /Name >

< Comment >

USB DEFAULT State

< /Comment >

< /State >