| Author |
Inserting SOAP formatted message data into a SQL table -- OPENXML
|
|
|
| Is configuring IIS to be used in conjunction with SQLXML a requirement for
the question I am asking?
My eventual goal is to insert the data present in the SOAP message into a
SQL table.
Please let me know how I can achieve this goal.
Thanks
| |
| William Stacey [MVP] 2005-05-21, 3:23 am |
| Could you just store in a nvarchar(max) ?
--
William Stacey [MVP]
"gudia" <gudia@discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A- A1795CE80728@microso
ft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
>
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
>
> Please let me know how I can achieve this goal.
>
> Thanks
| |
| Graeme Malcolm 2005-05-21, 9:23 am |
| There are a couple of approaches. You could pass the entire SOAP XML doc to
a stored procedure and use OPENXML to shred it into tables, or you could
create an annotated XSD schema that maps the elements/attributes in your
SOAP message to the tables/column in the database and use the SQLXML Bulk
Load component.
Neither of these approaches requires a SQLXML IIS site.
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A- A1795CE80728@microso
ft.com...
Is configuring IIS to be used in conjunction with SQLXML a requirement for
the question I am asking?
My eventual goal is to insert the data present in the SOAP message into a
SQL table.
Please let me know how I can achieve this goal.
Thanks
|
|
|
|