XML Import Solution

Question

Post reply

XML Import Solution

Girish Bhat

Ten Centuries

Points: 1323
More actions
October 8, 2008 at 10:12 pm

#194465

Comments posted to this topic are about the item XML Import Solution

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Morris-454316 SSC Veteran Points: 252 More actions · Answer 1

A nice solution for when you can't use SQL 2005 upwards, but surely the native XML features are now the way to go?

I say this as I sit at a client site who are trapped in SQL 2000 so recognising the value in this kind of solution!

blandry SSCarpal Tunnel Points: 4821 More actions · Answer 2

Thanks for a nice article on what appears to be a useful tool.

Over the last year we have been using SSIS to setup and run XML imports. We dont do any UNIX system work, only Windows, and the bulk of the XML we deal with is always in one of a few fixed formats.

Reading your article it seems this tool would be more work than what can be done fairly quickly in SSIS. Besides the GUI versus command line differences, are there any further advantages of this tool that would sway me toward it and away from SSIS?

Thanks again!

There's no such thing as dumb questions, only poorly thought-out answers...

gakster Valued Member Points: 59 More actions · Answer 3

We have done much of this using the XML Bulk Load with XSD that is part of the SQLXML add-in to SQL Server 2000.

Girish Bhat Ten Centuries Points: 1323 More actions · Answer 4

blandry (10/9/2008)
....Reading your article it seems this tool would be more work than what can be done fairly quickly in SSIS. Besides the GUI versus command line differences, are there any further advantages of this tool that would sway me toward it and away from SSIS?....

Hi Blandry - Using native features like SSIS is always better and should be used wherever possible. This article presents just another way to work with XML. The tool provides a simple way to process any xml format having any number of tag nesting levels or where XPath expressions need to be used. Also, SQL Server 2000 had DTS which did not have strong enough XML processing capabilities. This tool can be used there too.