Steps for extracting data from XML file

Asked By 0 points N/A Posted on -


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.

Answered By 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.

Login/Register to Answer

Related Questions