Solved

Can an xml file/data be loaded into a SQL Server database?  If Yes how is that done?

Posted on 2014-10-08
2
81 Views
Last Modified: 2016-02-13
We have a large xml file that needs to be loaded into a SQL Server database/table. Is this possible and if Yes, how is it done? We have a production version which is SQL Server 2005 and a development version which is SQL Server 2012 R2.
0
Comment
Question by:tesla764
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40368307
Yes.  SSIS can handle it using an XML task, loading an XML file into a table for each entity in the file.
0
 

Author Comment

by:tesla764
ID: 40368318
Can you give me an example of how that is done?  What should I look for (files/procedures) that would accomplish this. I am in a situation where the previous person that took care of this is out on mediacl leave and left no documentation or information behind.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

685 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