Monday, January 10, 2011

Flat File dissasembling and empty rows problem

  1. Set "suppress_trailing_delimiters" to "true" in your main node (works if empty lines are olny in the end).
  2. Set "suppress_empty_nodes" to "true" in schemainfo (should work if empty lines are in the middle as well, might cause isses if missing values in records are possible).
  3. Add special "empty" elements that correspond to empty lines to your schema (seems to be what Genuine Basil is doing).
  4. Clean the file up in receive pipeline (Might require some coding in your part).

No comments:

Post a Comment