Flat File/XSD formatting issue

I have a question regarding how the Flat File Schema wizard works. I have the following flat file example:

9|-@-|8|-@-|7|-@-|6|-@-|5|-@-|4|-@-|3|-@-|2|-@-|1
E|-@-|A|-@-|G|-@-|F|-@-|J|-@-|L|-@-|Y|-@-|W|-@-|M
X|-@-|Y|-@-|Z|-@-|A|-@-|K
1|-@-|2|-@-|3|-@-|4|-@-|5|-@-|6|-@-|7|-@-|8|-@-|9|-@-|10|-@-|11|-@-|12
A|-@-|B|-@-|C|-@-|D
77500264.pdf

The last 2 rows (with are filename attachments) can be repeating. The problem I am having is that when the XSD is produced and I try to validate the flat file instance seen above, the attachments aren’t shown.

In the Flat File Wizard, I break up each line by CRLF. I then break up the rows above the attachment names by |-@-| delimiter. I then break up the attachment by using the period as the delimiter for that row. The rest of the rows (which can also have multiple instances) render fine. It is the final row that I am having problems with. Any assistance I cna get with getting this final row to render would be great. The schema I am using is shown below:

<?xml version=\”1.0\” encoding=\”utf-16\” ?>
– <xs:schema xmlns:b=\”http://schemas.microsoft.com/BizTalk/2003\” xmlns=\”http://AgileToDatabase.AgileExtractToXML\” targetNamespace=\”http://AgileToDatabase.AgileExtractToXML\” xmlns:xs=\”http://www.w3.org/2001/XMLSchema\”>
– <xs:annotation>
– <xs:appinfo>
<schemaEditorExtension:schemaInfo namespaceAlias=\”b\” extensionClass=\”Microsoft.BizTalk.FlatFileExtension.FlatFileExtension\” standardName=\”Flat File\” xmlns:schemaEditorExtension=\”http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions\” />
<b:schemaInfo standard=\”Flat File\” codepage=\”65001\” default_pad_char=\”\” pad_char_type=\”char\” count_positions_by_byte=\”false\” parser_optimization=\”speed\” lookahead_depth=\”3\” suppress_empty_nodes=\”false\” generate_empty_nodes=\”true\” allow_early_termination=\”false\” early_terminate_optional_fields=\”false\” allow_message_breakup_of_infix_root=\”false\” compile_parse_tables=\”false\” root_reference=\”ECO\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”ECO\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”hex\” child_delimiter=\”0xD 0xA\” child_order=\”postfix\” sequence_number=\”1\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”CP\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|-@-|\” child_order=\”infix\” sequence_number=\”1\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”Cover_Page_Child1\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child2\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child3\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child4\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”4\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child5\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”5\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child6\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”6\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child7\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”7\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child8\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”8\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”Cover_Page_Child9\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”9\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
– <xs:element name=\”AIP\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|-@-|\” child_order=\”infix\” sequence_number=\”2\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”AI_Page_Child1\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child2\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child3\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child4\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”4\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child5\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”5\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child6\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”6\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child7\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”7\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child8\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”8\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Child9\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”9\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
– <xs:element name=\”AITB\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|-@-|\” child_order=\”infix\” sequence_number=\”3\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”AI_Title_Block_Child1\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Title_Block_Child2\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Title_Block_Child3\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Title_Block_Child4\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”4\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Title_Block_Child5\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”5\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
– <xs:element name=\”AIPT\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|-@-|\” child_order=\”infix\” sequence_number=\”4\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”AI_Page_Two_Child1\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child2\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child3\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child4\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”4\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child5\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”5\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child6\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”6\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child7\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”7\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child8\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”8\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child9\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”9\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child10\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”10\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child11\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”11\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_Page_Two_Child12\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”12\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
– <xs:element minOccurs=\”0\” maxOccurs=\”unbounded\” name=\”AIB\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|-@-|\” child_order=\”infix\” sequence_number=\”5\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<groupInfo sequence_number=\”0\” xmlns=\”http://schemas.microsoft.com/BizTalk/2003\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”AI_BOM_Child1\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_BOM_Child2\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_BOM_Child3\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
– <xs:element name=\”AI_BOM_Child4\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”4\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
– <xs:element minOccurs=\”0\” maxOccurs=\”unbounded\” name=\”Attachments\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”.\” child_order=\”default\” sequence_number=\”6\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</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=\”File_Name\”>
– <xs:annotation>
– <xs:appinfo>
<b:recordInfo structure=\”positional\” sequence_number=\”1\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” />
</xs:appinfo>
</xs:annotation>
– <xs:complexType>
– <xs:sequence>
– <xs:annotation>
– <xs:appinfo>
<b:groupInfo sequence_number=\”0\” />
</xs:appinfo>
</xs:annotation>
– <xs:element name=\”Item\” type=\”xs:string\”>
– <xs:annotation>
– <xs:appinfo>
<b:fieldInfo justification=\”left\” pos_offset=\”0\” pos_length=\”8\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>