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

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]