SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Girish Bhat / XML Import Solution / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 17:15:52 GMT20RE: XML Import Solutionhttp://www.sqlservercentral.com/Forums/Topic583059-1263-1.aspx[quote][b]blandry (10/9/2008)[/b][hr]....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?....[/quote]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.Thu, 09 Oct 2008 20:33:17 GMTGirish BhatRE: XML Import Solutionhttp://www.sqlservercentral.com/Forums/Topic583059-1263-1.aspxWe have done much of this using the XML Bulk Load with XSD that is part of the SQLXML add-in to SQL Server 2000.Thu, 09 Oct 2008 13:43:23 GMTgaksterRE: XML Import Solutionhttp://www.sqlservercentral.com/Forums/Topic583059-1263-1.aspxThanks 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!Thu, 09 Oct 2008 10:40:43 GMTblandryRE: XML Import Solutionhttp://www.sqlservercentral.com/Forums/Topic583059-1263-1.aspxA 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!Thu, 09 Oct 2008 08:35:02 GMTPhil Morris-454316XML Import Solutionhttp://www.sqlservercentral.com/Forums/Topic583059-1263-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/XML/63687/">XML Import Solution</A>[/B]Wed, 08 Oct 2008 22:12:09 GMTGirish Bhat