?
Solved

SQL 2008 R2 Parser

Posted on 2011-10-05
1
Medium Priority
?
323 Views
Last Modified: 2012-05-12
Hi All,

Is there a way to read an XML file into SQL Server genrically?  meaning how can i take any XML file and have the server read it into the database.


Any help on this is much appreciated.


Thanks!
0
Comment
Question by:MoreThanDoubled
1 Comment
 
LVL 21

Accepted Solution

by:
JestersGrind earned 2000 total points
ID: 36918050
You have a couple of options, bcp, BULK INSERT and using OPENROWSET.  Take a look at this article.

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

Greg

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

840 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