I am attempting to process a 4010 835 EDI file that contains multiple TRN segments by
1) having the receive location pick it up
2) the receive port contains an inbound map between the single X12_00401_835 schema and custom schema (structure below) to extract information from the EDI file
<Transactions> <Transaction> <TransactionRefId /> (Mapped to the TRN segment) <Date /> (Mapped to the TRN segment) <Payee /> (Mapped to the TRN segment) <Claims> <Claim> <PatientId /> <PatientName /> <AccountNumber /> </Claim> </Claims> </Transaction> </Transactions>
3) The EdiReceive pipeline then splits the EDI file on the TRN segment, so if there are 4 TRN segments in the file, then the EDI file is split into 4 files.
4) My send port then picks up each of the mapped XML blocks and calls a stored procedure over the WCF-SQL adapter 4 or however many files the EDI file has been split into.
My question is how can I process the EDI file so that I am just calling the stored procedure once? I know that the mapping needs to be in place & run through the EdiReceive pipeline in order to get the data in the format of my custom schema above, so I am wondering if leveraging an orchestration to call the EdiReceive pipeline & split the file, then eseentially put the contents back together before calling the stored procedure?
Any help would be much appreciated. Thanks
If you wish to insert all the TRN segment at once using the WCF-SQL adapter , then there is no point in debatching them at the receive side and then batching them for sending it to WCF-SQL.
http://biztalkguide.blogspot.com/ Please mark as answer if this solved the issue.Thanks