duplication of data

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › duplication of data

Viewing 0 reply threads
  • Author
    Posts
    • #18165

      Hello guys,

       

      We got two biztalk servers which are load balanced. We get the data from the db2 database and insert it into the sql database. The polling is done for every 1 hour.To avoid duplication of data, I created a staging table , in which the db2 execution time will be updated in the staging table when ever the data is inserted into the sql database, so if the new message arrives it checks in the staging table ,if the difference between the previous execution time and current time is greater than 60 min , then the row is inserted into the sql database, If not the message gets terminated. using this method also I am not able to avoid duplication of data inserting in the database. Can any one have answer for this with out clustering the two biztalk servers.

       Ram.

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