High Performance solution for a processing a BIG EDI file

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!

June 26th, 2015 2:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics