BizTalk Server Applications Integration - Flat File

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > July 2005 > Flat File





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Flat File
pj

2005-07-05, 5:51 pm

I've a flat file of format

ABCD,HR1
ABCD,AR11
ABCD,AR12
XXXX,HR2
XXXX,AR21
XXXX,AR22
XXXX,AR23
Z1Z1,HR3
Z1Z1,AR31

So, ABCD has a Header row HR1 & 2 detail rows AR11 & AR12. There can be any
number of "AR's" in one "HR"

Can BT04 create this as a single XML doc of the form

Transaction
Header
Type ABCD /Type
Ref HR1 /Ref
Detail
Type2 ABCD /Type2
Ref2 AR11 /Ref2
/ Detial
Detail
Type2 ABCD /Type2
Ref2 AR21 /Ref2
/ Detial
/Header
Header
Type XXXX /Type
. . . etc
/Header
/Transaction

It looks possible from the docs & discussions, but I can't seem to get it to
work ... not suprising as I'm fairly new to both BT & XML !

Thanks in advance.
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com