increment value in biztalk RRS feed

  • Question

  • I am receiving multiple messages in a batch into BizTalk and before this is sent to the target system, I need to add a incremental sequence number to a data field(Serial_ID) of each data row in the message and send to the target system. This is not the same as the total record count and if two records would have the same batchcode then the Serial_ID of these two records would be the same and only increment with the next record with different batchcode.

    what would be the ideal way to do this in BizTalk?

    Friday, April 3, 2020 3:18 AM

All replies

  • Sounds complicated.  And you aren't clear on whether the messages are getting debatched/rebatched etc.

    I would usually solve this by inserting the messages into a database, and then letting that do the incrementing/re-batching logic using either sequence numbers and or stored procedures.

    Friday, April 3, 2020 4:07 AM
  • Thanks Colin.

    All records would be in a single batch and need to be debatched as destination system accepts a single record and not batch.

    If I use SQL for the sequencing then that would need me to connect to another endpoint (the SQL send port)

    Friday, April 3, 2020 12:53 PM