Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
Medium Priority
?
89 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 66

Accepted Solution

by:
Jim Horn earned 1500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

572 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