Re: XML as Linked Server?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 08:16:07 -0000

You could write a routine which runs the XML through XSLT and outputs CSV
then continue as normal. 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"JDP@Work" <JPGMTNoSpam@sbcglobal.net> wrote in message
news:eNiZasD$DHA.268@TK2MSFTNGP10.phx.gbl...
> As with a csv file as a linked server I query the table and can
conditionally
> import data.
>
> I have a need to retrive order responses in XML and then update the
appropriate
> record.
>
> In a perfect world, I'd be able to view the XML data as a table and then
import
> and/or update records.
>
> In a less than perfect world I'll be importing the XML data adoc to a
stage
> table from there I'll parse and import into a final table and then from
there
> I'll update selected data in the live application database.
>
> TIA
>
> JeffP....
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:eoEPKVD$DHA.1732@TK2MSFTNGP12.phx.gbl...
> > Cute idea.  I like it.  In this release I do not know a way to do this.
> >
> > Send a wish to sqlwish@microsoft.com
> >
> > Are you after a Linked Server or simply a rowset exposed by taking
> >
> > 1 * XML document AND
> > 1 * XSD
> >
> > and marrying them up.
> >
> > I'm presuming that because you are in the DTS NG you want the latter.
> >
> > -- 
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.allisonmitchell.com - Expert SQL Server Consultancy.
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > "JDP@Work" <JPGMTNoSpam@sbcglobal.net> wrote in message
> > news:%23tKPlx3%23DHA.1844@TK2MSFTNGP11.phx.gbl...
> > > I've been working with csv files as linked servers....
> > >
> > > I'm starting to explore XML and was wondering if there is a way to
apply
> > the
> > > schema to enable an XML document to be a linked server?
> > >
> > > TIA
> > >
> > > JeffP.....
> > >
> > >
> >
> >
>
>

Relevant Pages