Steps for extracting data from XML file

Asked By lavanyasrkumar 0 points N/A Posted on - 07/27/2016

Hi.

I have been given a task in the office to extract data from XML source. So, what are the steps for extracting data from XML file? Reply ASAP. It is very urgent. Thanks a lot.

• Status: Open
• Question Views: 350
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: dBase

Answered By umahgod 0 points N/A #177583

Steps for extracting data from XML file

Hi. Extracting data from XML file is not a very complex procedure and involves the steps given below-

1) Open the integration services project first to select the package of your choice in SQL server data tools

2) Double-click to open the package selected by you

3) Select the data flow tab

4) From the toolbox, drag the XML to the surface of the design

5) The XML source needs to be double-clicked on

6) Browse the location of the XML file in the XML source editor

7) Click on use inline schema to include the schema information in the XML document

8) If you want to mention an external XML XSD schema for the file then, browse to locate the XSD file that exists already

9) If you wish to edit the names, then click on columns and edit the names written in the output column

10) Click on error output to construct the error output

11) Press OK

12) Click on file>save selected items to save the file which has been updated

Hope we helped.

About umahgod

Questions
0

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/27/2016
• Question Category: dBase