Hello,

I would like to design an orchestration which is activated when a
row in a sql table is updated or inserted and which takes different
actions depending on table insert or update. How is this achieved with
BizTalk Server 2004?

[ Post a follow-up to this message ]

Your starting point for reading up on how you might do something like this
should be our sql adapter. This will allow you to create a receive location
which will "listen" to your table and look for new rows and use the data in
those tables to trigger messages to be sent to your orchestration. You
could either read directly from your table or use something like a SQL
trigger to populate a side table with change notifications so that you
don't need to do destructive reads from your actual data table and can just
read and destroy the insert / update notifications. The place to start,
though, is with the SQL adapter.

HTH
Lee

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team
--------------------[vbcol=seagreen] 
12:21:58 GMT)[vbcol=seagreen] 
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!newsfeed.gamma.ru!Gamma.RU!newsfeed2.dallas1.leve
l3.net!news.level3.com!postnews2.google.com!not-for-mail[vbcol=seagreen] 

[ Post a follow-up to this message ]