|
Home > Archive > BizTalk Server General > June 2005 > HELP...SQLAdapter send to SQL Server
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 |
HELP...SQLAdapter send to SQL Server
|
|
| tfischer 2005-06-29, 5:51 pm |
| Is there a way that I can get BizTalk to send messages into a SQL
Server table? The samples I have looked at either require
Orchestration, or use receive ports.
All I want to do is receive a message from one of my BizTalk Receive
ports, then configure a send port so the message can go to the SQL
Server table.
Any help would be greatly appreciated.
| |
| Jeff Lynch 2005-06-30, 6:00 pm |
| Assuming you are using BTS2004 then you can use the SQL Send Adapter to
accomplish this. The easiest method is to create an Updategram schema (see
the documentation for an example), map to this schema and use this map in
your SQL Send Port. There is also a wizard to help create the updategram in
VS.NET 2003 under "Add Generated Items".
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"tfischer" <fischertm@hotmail.com> wrote in message
news:1120080226.433203.195910@o13g2000cwo.googlegroups.com...
> Is there a way that I can get BizTalk to send messages into a SQL
> Server table? The samples I have looked at either require
> Orchestration, or use receive ports.
>
> All I want to do is receive a message from one of my BizTalk Receive
> ports, then configure a send port so the message can go to the SQL
> Server table.
>
> Any help would be greatly appreciated.
>
| |
| tfischer 2005-06-30, 6:00 pm |
| I've tried the documentation and used the updategram, however I receive
error messages telling me that BTS could not find the stored procedure
LastName (other than the ID, this is the next node in the XML schema.
|
|
|
|
|