BizTalk Server Orchestration - How to pull data from SQL Server 2000 within an orchestration?

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > June 2004 > How to pull data from SQL Server 2000 within an orchestration?





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 How to pull data from SQL Server 2000 within an orchestration?
darin dimitrov

2004-06-26, 10:53 am

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?
Lee Graber [MSFT]

2004-06-26, 10:53 am

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]

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com