Biztalk Schema for varying role for a given partner

Background:
I have Biztalk 2010, SQL2008R2 backend. I have flat file source to Biztalk
which looks as follows. Field delimited “I” and Record Delimited “<CR><LF>”.

ENV|prt198623083932|…

PAR|TGL|01|104|D05|Partner
Name 1….

ROL|TGL|01|104|Role1 …

ROL|TGL|04|104|Role2 …

PAR|TGL|01|D104001|D05|Partner
2 …

ROL|TGL|01|D104001|Role 1
…

PAR|TGL|01|104|D052|Partner
Name 3….

ROL|TGL|01|1042|Role1 …

ROL|TGL|04|1042|Role2 …

ROL|TGL|01|1042|Role1 …

ROL|TGL|04|1042|Role2 …

 

One ENV
header, PAR with Varying Roles. Roles are at minimum 1 and maximum are unbounded.

 

Regardless
of what I do with Min, Max, Group Sequence etc. the schema does not recognizes
the varying partner “ROL”. Appreciate your help.

 

I have used
Biztalk standard tools and created a schema to import the records. It is as
follows. To keep it simple, I keep the details standard information out for now
and focus on the Partner and Role Sequence Group schema.

 

Thanks,
Toraj – [email protected]

 

–
<xs:sequence minOccurs=”1″ maxOccurs=”unbounded”>

–
<xs:annotation>

–
<xs:appinfo>

  <groupInfo
xmlns=”http://schemas.microsoft.com/BizTalk/2003&#8243;
sequence_number=”2″ />

  </xs:appinfo>

  </xs:annotation>

–
<xs:element minOccurs=”0″ maxOccurs=”unbounded”
name=”WraperPartnerRole”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:recordInfo
structure=”delimited”
preserve_delimiter_for_empty_data=”true”
suppress_trailing_delimiters=”false” sequence_number=”1″
/>

  </xs:appinfo>

  </xs:annotation>

–
<xs:complexType>

– <xs:sequence>

–
<xs:annotation>

–
<xs:appinfo>

  <b:groupInfo sequence_number=”0″
/>

  </xs:appinfo>

  </xs:annotation>

–
<xs:element maxOccurs=”unbounded” name=”Partner”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:recordInfo tag_name=”PAR”
structure=”delimited” child_delimiter_type=”char”
child_delimiter=”|” child_order=”prefix”
preserve_delimiter_for_empty_data=”true”
suppress_trailing_delimiters=”false” notes=”I) Each message file
must have at least one “Patner” segment. II) Each message file can
contain multiple “Patner” Segments, but only one per each
“env”.” sequence_number=”1″ />

  </xs:appinfo>

  </xs:annotation>

–
<xs:complexType>

–
<xs:sequence>

–
<xs:annotation>

–
<xs:appinfo>

  <groupInfo sequence_number=”0″
xmlns=”http://schemas.microsoft.com/BizTalk/2003&#8243; />

  </xs:appinfo>

  </xs:annotation>

–
<xs:element name=”Client” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”1″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”PartnerType” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”2″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”PartnerReference” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”3″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

…….

–
<xs:element name=”UserName” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”26″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”Date” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”27″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”Time” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”28″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

–
<xs:element maxOccurs=”unbounded” name=”Role”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:recordInfo tag_name=”ROL”
structure=”delimited” child_delimiter_type=”char”
child_delimiter=”|” child_order=”prefix”
preserve_delimiter_for_empty_data=”true”
suppress_trailing_delimiters=”false” notes=”Each
“Partner” segment will have one or more “Role” segment.”
sequence_number=”2″ />

  </xs:appinfo>

  </xs:annotation>

–
<xs:complexType>

–
<xs:sequence>

–
<xs:annotation>

–
<xs:appinfo>

  <groupInfo sequence_number=”0″
xmlns=”http://schemas.microsoft.com/BizTalk/2003&#8243; />

  </xs:appinfo>

  </xs:annotation>

–
<xs:element name=”Client” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”1″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”PartnerRoleType” type=”xs:string”>

– <xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”2″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

….

–
<xs:element name=”Date” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”6″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

–
<xs:element name=”Time” type=”xs:string”>

–
<xs:annotation>

–
<xs:appinfo>

  <b:fieldInfo
justification=”left” sequence_number=”7″ />

  </xs:appinfo>

  </xs:annotation>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>