SQL 2008 R2

Posted on 2011-10-05
Last Modified: 2012-05-12
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.
Question by:MoreThanDoubled
    LVL 21

    Expert Comment

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

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


    LVL 75

    Accepted Solution

    Providing you are not using SQL Server Express you can use SSIS.

    Author Comment

    well i guess my question wasnt clear, i was hopeing some one code proved some code or a step by step tutorial.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Unfortunately since you have not provided much in the way of feedback there is not a lot we can suggest.

    Good luck!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now