Ragged Right File:
This file is
similar to the fixed-width file only the difference is that this format file
allows the last line to be variable length.
Some time we
are not sure that the length of a column and we are extracting the data in the
fixed file in this case we can put the column at the last and store the data in
the fixed files.
See the below file.
See the mapping
Name: 0-20
Mobile: 21-35
Address: 36-
variable Length
Let’s see
how to load this file into the table.
Taking DFT
and source as a flat-file.
Selecting
the Format as Ragged Right.
In the
Columns we are mapping the column.
In the
advance we can see the list of columns with the length.
The preview we can see the data.
Now taking
Destination as OLEDB and doing the mapping.
The package is
ready to run.
See the
records in the table.
Running the package.
Data loaded
successfully.
See the
records in the table
Data loaded
successfully.
