|
Home > Archive > BizTalk Server General > June 2006 > Looking for pointer: SQL receive location
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 |
Looking for pointer: SQL receive location
|
|
| Don Rixtown 2006-06-27, 1:17 pm |
| Hi,
I'm trying to create a SQL receive location in BT2004 and I'm having
trouble finding some documentation or examples. I'm have a column in the
database that contains a serialized XML message.
Can someone point me in the direction of some documentation, or some
step-by-step examples?
Thanks,
Don
--
Don Rixtown
don[dot]rixtown[at]gmail[dot]com
| |
|
| Don,
You should be able to find something with the product
documentation,I would suggest you look into some of the sdk samples
which are available.
http://www.microsoft.com/downloads/...&displaylang=en
Don Rixtown wrote:
> Hi,
>
> I'm trying to create a SQL receive location in BT2004 and I'm having
> trouble finding some documentation or examples. I'm have a column in the
> database that contains a serialized XML message.
>
> Can someone point me in the direction of some documentation, or some
> step-by-step examples?
>
> Thanks,
> Don
>
> --
> Don Rixtown
> don[dot]rixtown[at]gmail[dot]com
| |
|
| Code project has an excellent example for biginners of using SQL
adapter with BizTalk 2004.
http://www.codeproject.com/dotnet/usingsqladapter.asp
Ana
Don Rixtown wrote:
> Hi,
>
> I'm trying to create a SQL receive location in BT2004 and I'm having
> trouble finding some documentation or examples. I'm have a column in the
> database that contains a serialized XML message.
>
> Can someone point me in the direction of some documentation, or some
> step-by-step examples?
>
> Thanks,
> Don
>
> --
> Don Rixtown
> don[dot]rixtown[at]gmail[dot]com
| |
| Greg Forsythe 2006-06-28, 7:17 pm |
| I can't remember ant specific documentation about using Xml in a SQL
colimun.
The thing to remember is SQL treats this as a string. So you have to do your
own parsing.
The SQL Adapter will create a schema
<root>
<column1/>
<columnxml/>
</root>
On a receive it will put the Xml string into the <columnxml> node this will
be encoded
i.e. <root>....
On send SQL will expect an encoded Xml string as well.
In an orchestration you can retrieve this using an XmlDocument variable
You will need to create your own schema to define this Xml.
stringVariable = sqlMessage.columnxml;
xmlDocVariable.LoadXml(stringVariable);
newMessage = xmlDocVariable;
You can put xml into a sql message like this
xmlDocVariable = incomingMessage;
sqlMessage.columnxml = xmlDocVariable.OuterXml;
Greg
"bomb" <bharathram@gmail.com> wrote in message
news:1151442372.251127.243850@x69g2000cwx.googlegroups.com...
> Don,
> You should be able to find something with the product
> documentation,I would suggest you look into some of the sdk samples
> which are available.
>
> http://www.microsoft.com/downloads/...&displaylang=en
>
> Don Rixtown wrote:
>
| |
| Leo Gan 2006-06-28, 7:17 pm |
| The strategy:
If you have one set of data to send to SQL you can use Schema with these
parameters: At first, create SP with set of parameters, then generate schema
on the base of your SP.
If you have rowset/dataset to send to SQL: you have to pack your data to
string and pass it to the SP as one parameter (Text type) (generate schema
on the base of your SP). Inside SP you have to use OPENXML to extract data
from this string.
Regards,
--
Leonid Ganeline
BizTalk Solution Developer
========================================
=
BizTalk blog -- http://geekswithblogs.net/leonidganeline
"Don Rixtown" <real.email.address@in.signature> wrote in message
news:MPG.1f0b0d23929cb62e989694@news.microsoft.com...
> Hi,
>
> I'm trying to create a SQL receive location in BT2004 and I'm having
> trouble finding some documentation or examples. I'm have a column in the
> database that contains a serialized XML message.
>
> Can someone point me in the direction of some documentation, or some
> step-by-step examples?
>
> Thanks,
> Don
>
> --
> Don Rixtown
> don[dot]rixtown[at]gmail[dot]com
|
|
|
|
|