Alternative to OpenXML

Hi,
I want to entere data in xml into tables in the database.
Howevere, I do not want to use OpenXML
Please let me know if there is an alternative.
Regards,
ShilpaWhat product are you using? XML is natively supported in SQL 2005. What
exactly are you trying to achieve?
ML
http://milambda.blogspot.com/

Alternative to OpenXML

Hi,
I want to entere data in xml into tables in the database.
Howevere, I do not want to use OpenXML
Please let me know if there is an alternative.
Regards,
ShilpaHello Shilpa,

> I want to entere data in xml into tables in the database.
> Howevere, I do not want to use OpenXML
> Please let me know if there is an alternative.
A lot depends on what you already have (is it a single file, many files,
is it coming in a stream from pipe, etc) and what you want to do with once
you have in SQL Server (e.g., you going to try to parse the XML into relatio
nal
tables or do you just want to store the data as is in one table?)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Another question is whether you are using SQL Server 2000 or 2005.
I would recommend that you look at the SQLXML components SQLXML Bulkload
functionality...
Best regards
Michael
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad7419f078c817ae36f52190@.news.microsoft.com...
> Hello Shilpa,
>
> A lot depends on what you already have (is it a single file, many files,
> is it coming in a stream from pipe, etc) and what you want to do with once
> you have in SQL Server (e.g., you going to try to parse the XML into
> relational tables or do you just want to store the data as is in one
> table?)
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>

Alternative to OpenXML

Hi,
I want to entere data in xml into tables in the database.
Howevere, I do not want to use OpenXML
Please let me know if there is an alternative.
Regards,
Shilpa
Hello Shilpa,

> I want to entere data in xml into tables in the database.
> Howevere, I do not want to use OpenXML
> Please let me know if there is an alternative.
A lot depends on what you already have (is it a single file, many files,
is it coming in a stream from pipe, etc) and what you want to do with once
you have in SQL Server (e.g., you going to try to parse the XML into relational
tables or do you just want to store the data as is in one table?)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||Another question is whether you are using SQL Server 2000 or 2005.
I would recommend that you look at the SQLXML components SQLXML Bulkload
functionality...
Best regards
Michael
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad7419f078c817ae36f52190@.news.microsoft.co m...
> Hello Shilpa,
>
> A lot depends on what you already have (is it a single file, many files,
> is it coming in a stream from pipe, etc) and what you want to do with once
> you have in SQL Server (e.g., you going to try to parse the XML into
> relational tables or do you just want to store the data as is in one
> table?)
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>