I am fairly new to BizTalk. I have become pretty good at using the mapping tool as well as XSLT (which I prefer), but there is one thing I'm not sure how to do. I need to insert info into a SQL table for each claim that we process. Part of the info I need is from the ISA and GS segments. Since that info is not present in the claim schema I cannot map it directly in the mapper. Is there a way to access that info in the mapper? Can it be accessed using C# from a scripting shape?

Thanks.

Raymond

Unfortunately, this is harder than it should be.  You have several options.

1.  The Context Accessor functoid: http://contextaccessor.codeplex.com/ and http://adifferentkindofquery.wordpress.com/2013/04/08/improved-context-accessor-functoid/

2. In an Orchestration, parse the values from the BTS.ISA_Segment Context Property and set them by either a Distinguished Field of xpath().

3. Create component that converts the Context to a Message and use a dual-input Map.

Hi,

Yes you can do it by fetching ISA and GS segment and then use it in map.

I have wrote an article , BizTalk Server 2010: Fetching ISA and GS Segment Values From Interchange Envelope and Mapping 

Mahesh, your article was very helpful. I was able to implement it and get access to all of the ISA and GS info. 

Thanks.

Raymond