The Read Fixed-width task can read data from text files and load that data into a RowSet variable. The variable's contents can then be imported into a database or translated into another file type like Excel,
CSV
, or
XML
.
Fixed-width files contain one or more columns using a predetermined length for each column. The size of each column must be specified by adding Column elements through the
Add
button in the sub-menu. Columns are added from left to right, always beginning on the first column position of the fixed-width file. The last column specified must end on a record delimiter (such as CRLF) or end on the last column in the record length.