Validations Required before starting polling in SQL receive adapter.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Validations Required before starting polling in SQL receive adapter.

Viewing 1 reply thread
  • Author
    Posts
    • February 1, 2008 at 9:36 PM #18861
      community-content

        I have a requirement that i need to check some conditions before starting polling from SQL receive adapter. I can check those conditions in Stored procedure, but i want the conditions to be configurable. So i can’t put the conditions in Stored procedure. My conditions are if the time is between 9AM-6PM pull 200 records from SQL adapter and if the time is between 12AM to 6AM pull 2000 records like that. Is there is any way to check these conditons before fetching records with out using stored proc for conditions.

      • February 6, 2008 at 3:06 AM #18882
        community-content

           

          You can use two different SQL Receive locations with schedule
          in receive port that is

          You can set timing by selecting ’Schedule’ option available in
          receive location.

          In your scenario

          First receive location pull 200 records from SQL and
          schedule 6PM to 12AM

          Second receive location pull 2000 records form SQL and
          schedule 12AM to 6PM

          Add Both Service locations in your receive port.

           

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