SQL Adapter

Viewing 1 reply thread
  • Author
    Posts
    • #14329

      Hi,
      Is there any way to let SSql Server know biztalk for any changes made to records instead of BTS constantly polling

      -Regards,

    • #14330

      Thanks Greg,

      I will check the new SQL Broker Adapter

      -Regards,

      • #14331

        You will need to use a Trigger to create a message and send this to Biztalk.
        There would be a number of options for sending the message including MSMQ or SQL Service Broker .

        Check out Jesus Rodriguez SQL Service Broker Enhancements on GotDotNet:
        [url]http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=f2e863c6-3444-47ae-8d13-668484a449f9[/url]

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.