The flat file output may not contain the flat file delimiters as expected in BizTalk Server 2006 and in BizTalk Server 2004 (914590)

WORKAROUND

1. Set the following properties on the potentially empty nodes in the document schema for the Flat File Assembler pipeline component:
   • Set the Preserve Delimiter for Empty Data property to the Yes value.
   • Set the Suppress Trailing Delimiter property to the No value.
   • On the root node, set the Generate Empty Nodes property to the True value.
2. Add a new map to the BizTalk project. In this map, use the document schema for the Flat File Assembler pipeline component as the source schema and as the destination schema.
3. In the map that you created in step 2, map the source fields that are not empty to the corresponding destination fields.
4. For the fields that may be empty in the input file, use a scripting functoid to return an empty string when the record is missing. The following code example for the scripting functoid demonstrates how to do this.

   public string ValOrEmpty(string val)
   {
        return (val.Length > 0) ? val : "";
   }
   

   Note You must create a script that has a unique function name for each potentially empty field that you map. For example, if you have three potentially empty fields, you may have functions that are named the following:
   • The ValOrEmpty1 function
   • The ValOrEmpty2 function
   • The ValOrEmpty3 function