BizTalk: Pick only particular number of files from folder based on configuration value and have to pick based on old date and time

Sathya Prakash 21 Reputation points
2021-11-25T15:17:44.497+00:00

I have a requirement to process particular number of files at a time (Lets say 3 files, even we had 10 files present in the folder location) and it should be start from old date time.

Could anyone suggest me the best approach to implement this?

Thanks

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
363 questions
0 comments
Accepted answer
  1. Colin Dijkgraaf 1,351 Reputation points
    2021-11-25T19:34:18.257+00:00

    You would either have to

    • Write your own file adapter with this functionality. I think there used to be a sample file adapter in the SDK for BizTalk, but not certain it is still there.
    • Alternatively, just use the normal file adapter and just save the contents and meta data (such as filename if needed) into a database table. Then have a stored procedure that ensure they are picked up 3 at a time and in the correct order. I don't think the file date is one of the properties that is retained, so unless the file contents contains the information you need to order it, you would have to go with making your own adapter.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.