biztalk port listening a SQL Server table

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › biztalk port listening a SQL Server table

Viewing 2 reply threads
  • Author
    Posts
    • March 21, 2007 at 11:28 AM #18081
      community-content

        Hi, i need to build a biztalk aplication able to listen an SQL Server table (like a trigger) so the biztalk orquestration got called in every new record and in the record eliminations.

         

        Any idea?

      • March 21, 2007 at 12:54 PM #18082
        community-content

          The SDK contains a sample (C:\Program Files\Microsoft BizTalk Server 2006\SDK\Samples\AdaptersUsage\SQLAdapter) where the SQL Adapter is used. It's also documented in the BizTalk Help file.

        • March 21, 2007 at 1:29 PM #18084
          community-content

            Most of the recieve adapter samples for sql server adapter show how to do this. Basically what you want is a polling service to retrieve information from SQL Server. That is exactly what the sql server receive adpater is ..check this out..http://msdn2.microsoft.com/en-us/library/ms935658.aspx make sure u implement the logic so that same message is not processed twice.

            -Mahesh 

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.