Re: How to upload data with XSD file

From: Graeme Malcolm (graemem_cm_at_hotmail.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 09:44:35 +0100

The SQLXML bits in the original release of SQL Server 2000 only supported
XDR. SQLXML 3.0 adds support for XSD. The file extension is irrelevant, the
schema is identified as an XSD schema by the namespace used in the
declaration.

If you've added annotations to your schema and it still doesn't work, there
might be a problem with your schema - can you post it?

Cheers,
Graeme 

-- 
----
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"Pro" <nospam@nospam.net> wrote in message
news:OWSL4TgQEHA.2976@TK2MSFTNGP10.phx.gbl...
> Thank you Graeme.
> Is the Bulk Load support XSD?
> I read through the document for bulkload and examples.  It users schema
file
> by extension XML instead of XSD.
> I've tried to use the XSD as schema file in a VBS.  It does not show error
> but insert nothing to the tables.
> Is there anything missing?
>
>
> "Graeme Malcolm" <graemem_cm@hotmail.com> wrote in message
> news:ePdmt4XQEHA.628@TK2MSFTNGP11.phx.gbl...
> > Download SQLXML 3.0 SP2
> >
>
(http://www.microsoft.com/downloads/details.aspx?FamilyID=4C8033A9-CF10-4E22
> > -8004-477098A407AC&displaylang=en). You can then add annotations to your
> XSD
> > schema that map the elements and attributes in the XML to tables and
> columns
> > in the database. After creating the mapping schema, you can use the
SQLXML
> > Bulk Load component in a script to perform the upload. All of this is
> > covered in the SQLXML documentation.
> >
> > Hope that helps,
> > Graeme
> > -- 
> > ----
> > Graeme Malcolm
> > Principal Technologist
> > Content Master Ltd.
> > www.contentmaster.com
> > www.microsoft.com/mspress/books/6137.asp
> >
> >
> > "Pro" <nospam@nospam.net> wrote in message
> > news:%23UBDKwVQEHA.2936@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > How can I upload a xml file with a schema in XSD file?
> > >
> > > Thank you.
> > >
> > >
> >
> >
>
>
>

Relevant Pages

  • Re: SQLXMLBulkLoad of text child nodes vs. attributes?
    ... You could use the XSDInference tool to get a XSD schema from xml. ... annotations to make it a proper sqlxml schema. ...
    (microsoft.public.sqlserver.xml)
  • Re: Dataset Schema from XSD
    ... Microsoft Online Support ... | Subject: Re: Dataset Schema from XSD ... | retrieve embeded file stream from assemlby's resource collection: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to upload data with XSD file
    ... You can then add annotations to your XSD ... After creating the mapping schema, you can use the SQLXML ... > How can I upload a xml file with a schema in XSD file? ...
    (microsoft.public.sqlserver.xml)
  • Re: how to construct a Schema
    ... Once you have the XSD authored - ... that's a way of checking IF a schema qualifies to be a dataset or not. ... > "Sahil Malik" wrote in message ... >>>> tables>> to>>>> be included into that schema.The reason I like the data is that .I>>>> want>> to>>>> pump data into a dataset,but I want to make sure that no viloation ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Any suggestion for a read/source (good one)? SQLXML
    ... Also have xsd Schema files, ... Can somebody point me to a good source that explains the "annotation" part ... The issue is that SQLXML Object for some reason does not like regular Schema ...
    (microsoft.public.sqlserver.xml)