Re: MSSQL2k retrive data from xml

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

From: "AJA" <ajanospam74@xxxxxxxxx>
Date: Wed, 4 Apr 2007 09:35:31 +0200

One thing that I'll suggest is that you get off of SQL Server 2000 DTS and look seriously at SQL Server 2005's SSIS bits. Much better for working with XML.

The problem is I can no change MSSQL to 2005 because its not my software. So i'm looking how to solve it in MSSQL 2k.

Best Regards
AJA

.

References:
- Re: MSSQL2k retrive data from xml
  - From: AJA
- Re: MSSQL2k retrive data from xml
  - From: Kent Tegels

Prev by Date: Re: Calling SQL Native Web Service failed as unauthorized
Next by Date: Re: Calling SQL Native Web Service failed as unauthorized
Previous by thread: Re: MSSQL2k retrive data from xml
Next by thread: RE: Query xml field in Query Plan DMV
Index(es):
- Date
- Thread

Relevant Pages

URGENT - Using XML Source - Related issues and usage
... Using XML Source - Related issues and usage ... Already tried to look for articles on the net and consulted Help inside SSIS ... The job is to get this XML data directly in to a SQL Server database table ...
(microsoft.public.sqlserver.xml)
Re: SQL/XML Annotation Question - a different take
... I guess the question you are referring is the SSIS question "how does ssis finds the relationship". ... SQL Server MVP ... Looked at some of the bigger XML files, they look very complicated, meaning multiple tables. ... That is the basis of my question: two different groups, putting out Schema's for people like me and we have to sort through huge xsd files to figure out multiple table relationships...just does not make sense. ...
(microsoft.public.sqlserver.xml)