XML Import Solution

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Girish Bhat » XML Import Solution

XML Import Solution

Rate Topic

Display Mode

Topic Options

Author

Message

Girish Bhat

Posted Wednesday, October 08, 2008 10:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:02 AM
Points: 206, Visits: 425

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

Post #583059

Phil Morris-454316

Posted Thursday, October 09, 2008 8:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 27, 2012 8:54 AM
Points: 6, Visits: 36

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!

Post #583363

blandry

Posted Thursday, October 09, 2008 10:40 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 07, 2012 9:23 AM
Points: 304, Visits: 716

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...

Post #583476

gakster

Posted Thursday, October 09, 2008 1:43 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, July 22, 2010 12:26 PM
Points: 53, Visits: 18

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.

Post #583582

Girish Bhat

Posted Thursday, October 09, 2008 8:33 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:02 AM
Points: 206, Visits: 425

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.

Post #583697

« Prev Topic | Next Topic »

Permissions