I need to process some 277U EDI files which are >150MB.
The Application is simple .. all i need to do is split the file into individual transactions get some required fields from each of them and make a SQL stored proc and pass those value and insert them into SQL table.
The issue i see is when i use EDIReceive Pipeline it would create about 150K transactions and i am afraid that these messages would flood the message Box (would occupy about 2GB space).
Would it be a good design to make all processing on Pipelines and avoid the messages from going into BizTalk Map?
Is there a way i can use Orchestration and Map and still achieve performance?
Thanks in Advance for your help!