Creating the Flat File Schema

When you create a flat file schema, keep the following points in mind:

You must have Write access to the folder in which you want to store the flat file schema.

You can quickly create a flat file schema by right-clicking the folder, selecting New > Flat File Schema. Enter a name for the flat file schema in the Provide a Name dialog box and click OK. Designer automatically creates a flat file schema in the selected folder.

To create a flat file schema

1. In the Package Navigator view of Designer, click File > New > Flat File Schema.

2. In the New Flat File Schema wizard, select the folder in which you want to save the flat file schema.

3. In the Element name field, type a name for the flat file schema using any combination of letters, numbers, and/or the underscore character. For information about restricted characters, see About Element Names.

4. Click Finish.

Integration Server generates a flat file schema and Designer displays it in the Package Navigator view.

5. Next, use the flat file schema editor to configure the record parser and record identifier. See Specifying a Record Parser.