Configuring Dataflow Options

This procedure describes how to configure a dataflow to support runtime options for Write to File stage.

  1. Open the dataflow in Enterprise Designer.
  2. If you want to configure runtime options for a stage in an embedded dataflow, open the embedded dataflow.
  3. Click the Dataflow Options icon on the toolbar or click Edit > Dataflow Options. The Dataflow Options dialog box appears.
  4. Click Add. The Define Dataflow Options dialog box appears.
  5. Expand the Write to File stage.
    The Dataflow options exposed are:
    1. Character Encoding
    2. Field Separator
    3. Text Qualifier
    4. Record Length
    5. First Row is Header Record
  6. The selected Write to File option name is displayed in Option name and Option label fields. This is the option name that will have to be specified at run time in order to set this option.
  7. Enter a description of the option in the Description field.
  8. In the Target field, select the option Selected stage(s).
  9. If you want to limit the values that can be specified at runtime, edit the options in the Legal values field by clicking on the icon just to the right of the field.
  10. If you want to change the default value, specify a different value in the Default value field.
    Note: For a service, you can only modify default values before exposing the service for the first time. Once you expose the service you can no longer modify default values using Enterprise Designer. Instead, you must use Management Console. For more information, see Specifying Default Service Options.
  11. Click OK.
  12. Continue adding options as desired.
  13. Click OK in the Dataflow Options dialog box when you are done adding options.
  14. Save and expose the dataflow.
Dataflow Options Rules
  1. Character Encoding: All encoding types that are valid for the underlying JVM are accepted. This option cannot be empty.
  2. Field Separator: Any single character delimiter is accepted. Currently, HEX values and spaces are not supported.
  3. Text Qualifier: Any single character qualifier is accepted. HEX values are not supported.
  4. Record Length: Only integers accepted. Cannot be blank or non numeric.
  5. Starting Record: Only integers accepted. Cannot be non numeric.
  6. Max records: Only integers accepted. Cannot be non numeric.
  7. First Row is Header: Only boolean values of true and false accepted. Cannot be blank.