Link to home
Start Free TrialLog in
Avatar of taslim shaikh
taslim shaikh

asked on

xml files


I've never worked with xml files.  I'm getting 30+ files with data that I need to load into sql table.  How do I do that

Thanks Taz
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

you can try openxml or xpath to do that.
if you want to automate the importing process, you probably can use SSIS or build a custom ETL program for that purposes.
Avatar of taslim shaikh
taslim shaikh


Hi Naitik Gamit,

The solution you suggested seems good but I get confused with the line below.  My xml files does not have the "ROOT" tag, it has page headers, totals, etc..

Help Taz

SELECT CustomerID, CustomerName, Address
FROM OPENXML(@hDoc, 'ROOT/Customers/Customer')
Avatar of Naitik Gamit
Naitik Gamit
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you