asked on

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?

Jim Horn

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

Frans_Truyens

ASKER

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?

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frans_Truyens

ASKER

What about ALTOVA products?

Frans_Truyens

ASKER

Thanks a lot.

Jim Horn

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.