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
MoreThanDoubledAsked:
Who is Participating?
 
Anthony PerkinsCommented:
Providing you are not using SQL Server Express you can use SSIS.
0
 
JestersGrindCommented:
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

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

Good luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.