Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem creating flat file schema (BT 2009)

0 views
Skip to first unread message

romet

unread,
Oct 7, 2009, 1:51:15 PM10/7/09
to
Hi,

I have problem creating BizTalk flat file schema. Flat file itself
looks this:

STR =DESADV
MSGID =123455
HEADER =BEGIN
HDR1 =4334
HDR2 =232
HEADER =END
LINES =BEGIN
LIN1 =1233
LIN2 =321
LIN1 =345
LIN2 =5431
LINES =END
END =DESADV

I would like the xml message to look something like this

<Message>
<MsgId>123455</MsgId>
<Header>
<Hdr1>4334</Hdr1>
<Hdr2>232</Hdr2>
<Header>
<Body>
<Line>
<Lin1>1233</Lin1>
<Lin2>321</Lin2>
</Line>
<Line>
<Lin1>345</Lin1>
<Lin2>5431</Lin2>
</Line>
<Body>
</Message>

The XML format could be something else, if it easier to do.

What is the easiest way to extract the values from TAG INDENTIFICATOR
= VALUE?
How the repeating lines could be handled? There is no separator
between lines.

I’m using Biztalk 2009

Thanks,
Romet

Karthick

unread,
Oct 7, 2009, 10:26:01 PM10/7/09
to
Hi Romet,

See my post in
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.biztalk.general&cat=en_US_422645f0-7d49-4b02-8fbc-55867e389462&lang=en&cr=US

Use HEADER and END as tag identifier for your schema and make LINES max
occur = unbounded.

Cheers,
Karthick G.

Dorairaj@discussions.microsoft.com Ramprasad Dorairaj

unread,
Nov 9, 2009, 8:44:02 PM11/9/09
to
Hi Romet,
Do you still have issues in this? I would suggest you to use the Define
Record from flat file instance, which is very easy to use.

Thanks,
Ram.

0 new messages