XML Import Solution

  • Girish Bhat

    Ten Centuries

    Points: 1323

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

  • Phil Morris-454316

    SSC Veteran

    Points: 252

    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

    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

    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

    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.

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

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