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
BizTalk Server > BizTalk Server General
Comments
Post a Comment