|
Home > Archive > BizTalk Server > March 2004 > Receiving from SQL
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 |
Receiving from SQL
|
|
| Mark Mergler 2004-03-18, 1:59 pm |
| Hello,
I'd like to reveice data from SQL created from a trigger on an SQL table.
i.e. when a record gets added to the SQL table the trigger creates and XML
version of that data and BT picks it up.
Can this be done and if so how?
Does the data coming from SQL have to be XML?
Sorry but I am very, very new to this!
Thanks
| |
| Jan Eliasen 2004-03-18, 1:59 pm |
| On Thu, 18 Mar 2004 10:47:25 -0000, "Mark Mergler"
<markm@conran-restaurants.co.uk> wrote:
To my knowledge (which only applies to BizTalk 2002), you can't do
this exactly. But with the BizTalk Adapter for SQL Server, you can
look for rows in a table each second, minute, hour or a combination of
these. Take a look at it to see if it matches your requirements.
>Hello,
>
>I'd like to reveice data from SQL created from a trigger on an SQL table.
>i.e. when a record gets added to the SQL table the trigger creates and XML
>version of that data and BT picks it up.
>
>Can this be done and if so how?
>Does the data coming from SQL have to be XML?
>
>Sorry but I am very, very new to this!
>
>Thanks
>
>
--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server
|
|
|
|
|