A valiant effort indeed Snake, but I've Googled it to absolute pieces. I've seen that article too... My code to use the object is fine - it's just blowing up on what it finds in the schema. It doesn't like the fact that the types are derived from multiple bases. That doesn't seem to me like it should be a problem, but maybe someone else knows better...
Thanks, Ken Ferguson 214.636.6126 -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, August 21, 2006 9:08 AM To: CF-Talk Subject: RE: XML and SQL Server 05 Does this help? http://www.awprofessional.com/articles/article.asp?p=102307&seqNum=13&rl =1 Snake -----Original Message----- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 21 August 2006 14:57 To: CF-Talk Subject: OT: XML and SQL Server 05 I've got something that's a bit OT here. I was going to write something to parse all of this XML against these XSD's, but I just don't want to do it. All I want is to be able to import the data right into SQL Server. I know that xml works as a datatype in SQL Server 05, but that's not what I need. What I need is XML Bulk Insert. I've written a VBScript to run the bulk insert with the xml and the schema. I was so excited that I was about to watch all that data just fly into the db. But of course, reality had to show its ugly head. Instead of a bunch of data, I got only one frustrating error message: "Multiple base for derived type is not supported" - that's the message. What do you mean it's not supported? Multiple types are basic. Does anyone have any experience with this and if so, would you be willing to give me a few pointers? I have a almost a gig of xml data I need to import against a schema that is about 12,340 lines long! Thanks, Ken Ferguson 214.636.6126 www.fergusonhouse.com <http://www.fergusonhouse.com/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
