Re: How to upload data with XSD file

From: Pro (nospam_at_nospam.net)
Date: 05/25/04 

Date: Tue, 25 May 2004 11:05:12 +0800

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

  • my first Tck/Tk program... and an XML question
    ... program which takes an XML Schema file, ... a basic XML tree and allows the user to save it. ... proc open_schema { ...
    (comp.lang.tcl)
  • Re: XML Literals in VB9 - Whats wring with this?
    ... As for generating xsd scheme, .net framework does provide a tool "xsd.exe", ... it can help you generate xsd from a given sample XML document or generate ... However, since it's code logic is quite simple, the generated schema or ...
    (microsoft.public.dotnet.languages.vb)
  • 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: Simple mapping question
    ... Yeap created the XSD for the source and destination, ... The destination schema in your case should be a flat file schema. ... There isn't an XML schema ... ...
    (microsoft.public.biztalk.general)
  • RE: 2.0 dataset issues - again
    ... As for the first question on XML error, ... met is due to the XSD validation of the XML Editor... ... schemas and VS IDE's install directory will contains a copy of these schema ...
    (microsoft.public.dotnet.framework.aspnet)