- This topic has 1 reply, 1 voice, and was last updated 9 years, 1 month ago by
.
-
Posts
-
-
Hi,
Up until now I have only used BizTalk to receive a flat file and transform it to an XML format and then send it. In this setup BizTalk listens to a specific folder and as soon as there is a file in that folder BT takes it in. My question is what other ways there is to trigger a BT process have i understand it correctly that it can work with an table in an SQL Server DB as an input but what triggers it?
Does anyone have any tips on reading about using BizTalk where an SQL Server (table) is the source input instead of eg. a flatfile?
Thank you!
-
The SQL Receive adapter is a polling adapter, it will execute the configured query or stored procedure at an interval you specify and return some records as an Xml message, or possibly no message if there are no records that meet the criteria.
e.g
Create PROCEDURE bts_PollTable AS
SELECT * FROM myTable WHERE Status='New' FOR XML AUTO, ELEMENTS
UPDATE myTable SET Status='Processed' WHERE Status='New'
GO
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.