|
Home > Archive > BizTalk Server General > June 2006 > Passing XML data type to a SQL Server 2005 procedure (BizTalk 2006)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Passing XML data type to a SQL Server 2005 procedure (BizTalk 2006)
|
|
| bouchaet 2006-06-21, 1:17 pm |
| Hello,
I'm using a stored procedure in SQL Server 2005 that can receive a XML
parameter (with the new XML data type available with SQL Server 2005).
The SQL adapter wizard generates a schema to make the request to the
database, which maps the XML data type as a xs:string into an attribute
element.
I would like to map a entire schema into that attribute but couldn't
find a simple way of doing it with any functoids and links. In other
words, I would like to map the entire source schema (left side) into
this one attribute (right side). Is it possible with the tools we have
in BizTalk06 Map?
I did make it with a custom XSLT file but I was wondering if the tools
available with the BTS2006 Map could done the trick also?
=E9tienne
| |
|
|
"bouchaet" <bouchaet@gmail.com> wrote in message
news:1150904958.611201.302660@p79g2000cwp.googlegroups.com...
Have you tried using the "Mass Copy" functoid? If you set the input of the
functoid to be the root of your source document, and the output to be the
target attribute, you may be able to achieve what you want if you set the
"Source links" property of the connector lines to "Copy text and subcontent
value." Not sure if it'll work, but worth a shot....
Paul Brinkle-Rogers
I'm using a stored procedure in SQL Server 2005 that can receive a XML
parameter (with the new XML data type available with SQL Server 2005).
The SQL adapter wizard generates a schema to make the request to the
database, which maps the XML data type as a xs:string into an attribute
element.
I would like to map a entire schema into that attribute but couldn't
find a simple way of doing it with any functoids and links. In other
words, I would like to map the entire source schema (left side) into
this one attribute (right side). Is it possible with the tools we have
in BizTalk06 Map?
I did make it with a custom XSLT file but I was wondering if the tools
available with the BTS2006 Map could done the trick also?
étienne
| |
| Matt Milner 2006-06-23, 1:18 pm |
| I've got a sample of sending XML as a text parameter to a SQL database. You
should be able to use it for your purpose though.
http://www.pluralsight.com/matt/dow...qlxmlsample.zip
The key is to use the map (or some other mechanism) to initially construct
the structure of the message. Then you use a distinguished property for the
attribute that represents your parameter so you can set it in the assignment
shape.
Feel free to post questions or contact me from my blog if you need help with
the sample.
Matt
http://www.pluralsight.com/blogs/matt/
"bouchaet" <bouchaet@gmail.com> wrote in message
news:1150904958.611201.302660@p79g2000cwp.googlegroups.com...
Hello,
I'm using a stored procedure in SQL Server 2005 that can receive a XML
parameter (with the new XML data type available with SQL Server 2005).
The SQL adapter wizard generates a schema to make the request to the
database, which maps the XML data type as a xs:string into an attribute
element.
I would like to map a entire schema into that attribute but couldn't
find a simple way of doing it with any functoids and links. In other
words, I would like to map the entire source schema (left side) into
this one attribute (right side). Is it possible with the tools we have
in BizTalk06 Map?
I did make it with a custom XSLT file but I was wondering if the tools
available with the BTS2006 Map could done the trick also?
étienne
|
|
|
|
|