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.