| Andy's profileAndy's WarholeBlogLists | Help |
Positional Flat File ChallengeLately I was struggling designing a schema for a positional flat file without tag identifiers.
The file contains a header, data rows and a footer where the length of a row is 230 characters. The format is as follows:
<headerfield1><headerfield2><headerfield3><field4><filler> <field1><field2><field3><field4><...> <field1><field2><field3><field4><...> ... <footerfield1><footerfield2><footerfield3><filler> I tried designing a schema, but it results in only 1 data row, and the data of the other data rows end up in the footer. When I edit the source file so that it does have tag identifiers, it results in the desired result.
After some rearch and consultation, see the 'Positional Flat File without Tag Identifiers' topic on the MSDN BizTalk forum, I was finally concluded that this cannot be done out of the box. Thanks Jan Eliasen for the help.
TrackbacksThe trackback URL for this entry is: http://andymater.spaces.live.com/blog/cns!E8E1E7ADD43D35FA!318.trak Weblogs that reference this entry
|
|
|