Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Import Solution Expand / Collapse
Author
Message
Posted Wednesday, October 8, 2008 10:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, March 31, 2014 1:03 AM
Points: 215, Visits: 428
Comments posted to this topic are about the item XML Import Solution
Post #583059
Posted Thursday, October 9, 2008 8:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 9, 2008 10:40 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 7, 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
Posted Thursday, October 9, 2008 1:43 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Thursday, October 9, 2008 8:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, March 31, 2014 1:03 AM
Points: 215, Visits: 428
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 »

Add to briefcase

Permissions Expand / Collapse