Fixed Length File Source

Centerprise Fixed-Length File Source provides a high-speed reader for files containing fixed length records. Fixed-Length File Source supports records with delimiters as well as without delimiters. Key features are discussed in the following subsections:

Encodings and Character Sets

Centerprise supports a wide range of encodings and character sets including double byte and multi byte character sets.

Data Formats

With Centerprise, you can parse dates, numbers, and Boolean values in virtually any formats. Centerprise comes with a set of built-in formats for dates, numbers, and Boolean values and provides the ability to define additional formats.

Filtering

Often, files contain rows that must be skipped. With Centerprise, you can specify criteria for rows that are skipped before parsing. This way, if the file contains multiple types of rows, Centerprise processes only the rows that meet your criteria.

Hierarchical Files

Businesses often exchange complex transactions in the form of hierarchical fixed-length files. Centerprise Fixed-Length File Source provides support for hierarchical files. You can define hierarchical file layout and process the data file as a hierarchical file. Centerprise IDE provides extensive user interface capabilities for processing hierarchical structures.

Layout Building

Centerprise Fixed-Length File Source features a visual layout builder that facilitates building of fixed length layout by visually marking start positions. Often, layout specifications are defined in Excel files that contain field names, data types, start positions, and lengths. You can import these specifications in Centerprise and quickly build fixed-length layout using these specifications.

COBOL Files

If you are working with COBOL files and do not have COBOL copybooks, you can still import this data by visually marking fields in the layout builder and specifying field data types. For more advanced parsing of COBOL files, you can use Centerprise COBOL File Source.

Steps

Adding a fixed-length file source object allows you to transfer data from a fixed-length file. An example of what a fixed-length file source object looks like is shown below.

To configure the properties of a Fixed-Length Source object after it was added to the dataflow, right-click on it and select Properties from the context menu.