Re: How to upload data with XSD file

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

Date: Tue, 25 May 2004 11:36:44 +0100

Can you paste them into the message - my newsreader removes attachments. 

-- 
----
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:OhaNKMkQEHA.1340@TK2MSFTNGP12.phx.gbl...
> Dear Graeme,
>
> Attached are the schema.
>
>
> "Graeme Malcolm" <graemem_cm@hotmail.com> wrote in message
> news:eo8OFSjQEHA.2468@TK2MSFTNGP11.phx.gbl...
> > 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: 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 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)
  • using and caching multiple schema in ASP.NET C#
    ... Im trying to cache xsd s that have a targetnamespace that is a URI. ... to the Schema) ... Basado en XBRL 2.1. ...
    (microsoft.public.dotnet.xml)
  • Re: Generate DataSet in 2.0?
    ... Create the xsd schema. ... Copy the manual xsd schema information to the clipboard. ... You now have a strongly-typed Dataset based on your manually-built xsd schema. ...
    (microsoft.public.dotnet.framework.adonet)
  • Importing xml document to sql 2000 server using xsd schema.
    ... I am trying to import xml documet to sqltable using bulkload and ... i change the schema and make is ... XRD WITH THE SAME XML DOCUMENT ITS WORK BUT ITS DOESNOT WORK WITH XSD. ... <ExportTourComments> ...
    (microsoft.public.sqlserver.xml)