Re: openxml question


"JRStern" <JRStern@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F59EC99-46F2-4F48-99CF-F453DCD947C1@xxxxxxxxxxxxxxxx
My pardon, I was using openrowset('bulk ...'), and I guess that is using
the
XML datatype for shredding.

?

Are you actually shredding the XML data after you load it using
openrowset(...) or are you actually just storing it an an XML type variable
or column? I ask because casting character/binary data to XML and shredding
it to relational format are two completely different tasks.


.

Relevant Pages

  • Re: SSIS 2005 - lading multiple XML files
    ... Do you want to insert the document en masse into your XML column or do you ... want to do shredding of the XML data within the SSIS pipeline? ...
    (microsoft.public.sqlserver.dts)
  • Re: openxml question
    ... openrowsetor are you actually just storing it an an XML type ... The shredding is indecently fast. ... complicated paths or XML documents yet. ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml question
    ... shredding an XML type column with nodesmethod and primary XML index ... OPENXML appears to be slightly faster for simple XML documents, ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml question
    ... The secondary XML index doesn't seem to ... Secondary XML indexes may improve performance for complex ... Anyway, when I'm shredding a 2mb, 2000 row document in two seconds, how ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml question
    ... I ask because casting character/binary data to XML and shredding ... Cast it to XML variable with schema to validate via XSD. ... The shredding is indecently fast. ...
    (microsoft.public.sqlserver.xml)
Loading