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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

Import complex XML in MS SQL Server

I am looking for a tool to import complex XML files into MS SQL Server. I am working with the Express Edition of MS SQL Server 2008. Should I go for ALTOVA? Or are there other possibilities?
0
Frans_Truyens
Asked:
Frans_Truyens
  • 3
  • 3
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Define 'complex', preferably by copy-pasting a fragment or three into this question.

SSIS can handle XML sources, although there are some limitations such as it can handle only one namespace.

Either way, I've had success with Pragmatic Works' Task Factory as an SSIS third-party addin for shredding XML and a bunch of other functions, such as INSERT and UPDATE in one command, FSO tasks, zip, and rich-text emails.

Good luck.
Jim
0
 
Frans_TruyensAuthor Commented:
I am rather new to complex XML. I mean XML with lot's of nodes in it. It is just a bunch of structured data. Is SSIS included in the Express version of MS SQL Server?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I am rather new to complex XML.
Both SSIS (really any ETL tool) and XML have somewhat steep learning curves, so just to set expectations if you're new to both then you're about to go down a long road.

>Is SSIS included in the Express version of MS SQL Server?
SSIS is a part of SQL Server Data Tools (SSDT), which is a part of SQL 2012.  Not sure about licensing or 2014, although I've purchased Developer versions in 2008 and 2012 that includes the entire BI suite off of Amazon.com for something like $50.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Frans_TruyensAuthor Commented:
What about ALTOVA products?
0
 
Frans_TruyensAuthor Commented:
Thanks a lot.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Can't help you on ALTOVA products, as I don't know anything about them.

I attended a Querying XML session at SQL Saturday Minnesota last weekend that was a really good beginner tutorial for understanding XML.  Click and download, open the PowerPoint, then follow the scripts.

Also, Pragmatic Works has a lot of free training on SSIS, and you can search all sessions over the last couple of years.  I also HIGHLY recommend their SSIS workshop.  Best two days and $400 you'll ever spend on learning SSIS.

Of course, there's always asking questions here at Experts Exchange.

Good luck.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now