Mapping multiple rows into one record in a SQL table


i having issue mapping inbound edi document. source schema edi schema , destination schema sql stored procedure schema. 

the issue facing is,

in input schema there sln record occur 2 times in incoming file. have map 2 sln records in incoming file single record in sql table. current map getting 2 separate rows in sql table. table has required columns hold data 2 sln records.

so there way can map 2 sln records can insert them 1 record in sql table , prevent generating 2 individual records 2 sln records in source

thanks


sree

you can use index functoid on each of 2 incoming segments.  have linked field field.


BizTalk Server  >  BizTalk Server General



Comments

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

How to Share webservice object to all user