Link to home
Start Free TrialLog in
Avatar of MoreThanDoubled
MoreThanDoubled

asked on

SQL 2008 R2

All, i have been serarching the internet to find the latest and greatest way to parse through XML code using SQL Server 2008 R2.  Using openrowset and bulk is not an option for me.

Please can someone provide me with the latest and greatest way to parse through xml code usnig SQL server 2008 R2.  The XML file that needs to be parsed is attached.
Example7.txt
Avatar of JestersGrind
JestersGrind
Flag of United States of America image

If you can't use OPENROWSET or BULK, bcp might be your only other option.  

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Actually, maybe you could use the import/export wizard as well.

Greg

ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

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

ASKER

well i guess my question wasnt clear, i was hopeing some one code proved some code or a step by step tutorial.
Unfortunately since you have not provided much in the way of feedback there is not a lot we can suggest.

Good luck!